Written by me@grafxflow
04 May, 2011
1
6,629
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]'
12 Jan, 2010
08 Nov, 2012
28 Nov, 2012
I am a Full-stack Developer who also started delving into the world of UX/UI Design a few years back. I blog and tweet to hopefully share a little bit of knowledge that can help others around the web. Thanks for stopping by!
Follow
11 Jul, 2023
21 Jun, 2023
Views: 166,583
Views: 40,465
Views: 37,234
Views: 33,736
1 Response
Rachit
05 Dec 2019
Thanks for this. I was facing the dame issue and found your blog. Really helpful