MySQL BINARY Function

❮ Previous ❮ MySQL Functions Next ❯

Example

Convert a value to a binary string:

SELECT BINARY "W3Schools.com";

Try it Yourself »

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

Parameter	Description
value	Required. The value to convert

Technical Details

Works in:	From MySQL 4.0

More Examples

Example

Here MySQL performs a character-by-character comparison of "HELLO" and "hello" and return 1 (because on a character-by-character basis, they are equivalent):

SELECT "HELLO" = "hello";

Try it Yourself »

Example

Here MySQL performs a byte-by-byte comparison of "HELLO" and "hello" and return 0 (because on a byte-by-byte basis, they are NOT equivalent):

SELECT BINARY "HELLO" = "hello";

Try it Yourself »

❮ Previous ❮ MySQL Functions Next ❯