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%'
Code: Select all
SELECT name FROM table WHERE name LIKE 'a%'
Code: Select all
SELECT name FROM table WHERE name LIKE BINARY 'a%';
Code: Select all
SELECT name FROM table WHERE name REGEXP BINARY '^[a-z]';