Written by me@grafxflow
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]'Topics
Smart Search
Latest Articles
The Ultimate Preservation? Reviewing the Stereoscopic 3D Fan Edits of Star Wars
121 views
The Falcon Needs a Refurb: The 3-Step Blueprint to Save the Star Wars Universe
701 views
Darth Maul and Micro-Organisms: Inside George Lucas's Cancelled Star Wars Sequel Trilogy
205 views
How to Automatically Convert DVD Subtitles to SRT on Mac
129 views
The $4 Billion Divorce: Inside the Awkward, Painful Sale of Lucasfilm to Disney
134 views
The Rift That Broke the Whip: Inside Lucas, Spielberg, and Harrison Ford's 'Furious Rows' Over Indiana Jones
369 views
Popular Articles
Markdown Syntax Cheatsheet
421,786 views
How to install GitLab CE with Vagrant on macOS
310,294 views
Disable macOS 11 (Big Sur) 'kernel_task' which is throttling the CPU
226,315 views
Shadow Catcher plugin in Cinema 4D - Part 1
176,429 views
Defective AMD GPU fix on Macbook Pro 2011
153,709 views
Adding an email template for apple mac mail.app
146,383 views
Popular Tags
me@grafxflow
Founder, Grafxflow
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. I build lighting-fast dynamic content engines with Laravel, Winter CMS and Tailwind CSS. Thanks for stopping by!
Rachit
05 Dec 2019
Thanks for this. I was facing the dame issue and found your blog. Really helpful