Knowledge Walls
John Peter
Pune, Maharashtra, India
Case sensitive string comparison in mysql with example
3483 Views
BIINARY Operator 
BINARY Operator in Mysql is supports Case Sensitive comparison of two strings. = operators used to compare character by character. BINARY operator is used to compare two strings byte by byte.
Example
SELECT 'b' = 'B';
# Returns 1

SELECT BINARY 'b' = 'B';
# Returns 0

SELECT BINARY 'God' = 'GOD','God' = 'GOD';
Output 
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details