MySQL: String comparison

This entry is part 25 of 26 in the series Learn MySQL

Here you might be surprised when you ran the comparison tests for the 2 expressions below.

SELECT 'ABC' = 'abc';
SELECT 'ABC' = 'abcd';

The first expression evaluates to 1 or true and the second expression evaluates to 0 or false.




Series Navigation<< MySQL: Mathematical expression
MySQL: Check current database >>

Leave a comment

Leave a Reply