bugl
bugl
HomeLearnPatternsPathsSearch
HomeLearnPatternsPathsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL BINARY Function

Flash cards

Review the key moves

1/4
Core idea

What is the main idea behind MySQL BINARY Function?

Lesson checks

Practice each idea before moving on

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ BINARY "ExampleSite.com";
3Order

Put the learning moves in the order that makes the concept easiest to apply.

The BINARY function converts a value to a binary string.
Definition and Usage
MySQL BINARY Function

Example

SELECT BINARY "ExampleSite.com";

Definition and Usage

The BINARY function converts a value to a binary string.

This function is equivalent to using CAST(value AS BINARY) .

Syntax

BINARY
 value

Parameter Values

ParameterDescription
valueRequired. The value to convert

Technical Details

Works in:From MySQL 4.0

Previous

MySQL BIN() Function

Next

MySQL CASE Function