MySQL Icon Logo
me@grafxflow

Written by me@grafxflow

04 May, 2011

1

6,238

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]'

Add comment

1 Response

  1. avatar

    Rachit

    05 Dec 2019
    Thanks for this. I was facing the dame issue and found your blog. Really helpful

Smart Search

119 Following
50 Followers

me@grafxflow

Hull, United Kingdom

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