Use LIKE BINARY
:
mysql> SELECT 'abc' LIKE 'ABC';
-> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';
-> 0
More Related Contents:
- How can I make SQL case sensitive string comparison on MySQL?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- MySQL Like multiple values
- Like Case Sensitive in MySQL
- SQL unique varchar case sensitivity question
- Mysql: Order by like?
- how to use a like with a join in sql?
- get first occurrence of last changed value of a column [closed]
- SQL Print the name of all Employees together with the name of their supervisor
- MySQL – Rows to Columns
- ROW_NUMBER() in MySQL
- How can I temporarily disable a foreign key constraint in MySQL?
- MySQL offset infinite rows
- Ordering by the order of values in a SQL IN() clause
- Creating a “Numbers Table” in MySQL
- SQL Selecting from two Tables with inner join and limit [duplicate]
- MySQL Group by SUM
- In SQL, how to select the top 2 rows for each group
- Are column and table name case sensitive in MySQL?
- Mysql query to dynamically convert rows to columns on the basis of two columns
- MySQL Error 1264: out of range value for column
- Special Characters in MySQL Table Name
- MySQL: How do I join same table multiple times?
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- Empty IN clause parameter list in MySQL
- creating a random number using MYSQL
- #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
- How to speed up sql queries ? Indexes?
- Strip last two characters of a column in MySQL
- is there a length limit to group_concat or another reason why it would not work on a text field