MYSQL Select values containing any UpperCase characters
I recently had a problem searching for values containing any uppercase characters in a MYSQL database. I had this little query but with no luck.
SELECT * FROM 'table' WHERE 'column' REGEXP '[A-Z]'
But when adding BINARY all worked well. BINARY makes an exact match to the value.
SELECT * FROM 'table' WHERE 'column' REGEXP BINARY '[A-Z]'
Visitors also viewed these posts