SOLVED: mysql compare case-sensitive
Posted: Sat Aug 27, 2016 2:46 pm
The queries are case insensitive.
That is good for most cases.
But now I want a case sensitive search.
For example all names starting with a small 'a'
That is good for most cases.
But now I want a case sensitive search.
For example all names starting with a small 'a'
Code: Select all
SELECT name FROM table WHERE name LIKE 'a%'