MySQL BINARY Function

Example

SELECT BINARY "W3Schools.com";

Definition and Usage

This function is equivalent to using

Syntax

Binary

Parameter Values

Parameter

Description value

Technical Details

Works in:

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";

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";

Previous

Next