Menu
I want to check, if a string consits only of uppercase letters. I know that RLIKE/REGEXP are not case sensitive in MySQL. So I tried to use the :upper: character class:
SELECT 'z' REGEXP '^[[:upper:]]+$'; This gives true, although the z is in lower case,... why?
569
The UPPER() function converts a string to upper-case.
Case insensitive SQL SELECT: Use upper or lower functionsselect * from users where lower(first_name) = 'fred'; As you can see, the pattern is to make the field you're searching into uppercase or lowercase, and then make your search string also be uppercase or lowercase to match the SQL function you've used.
If you want to upper-case the first letter and lower-case the other, you just have to use LCASE function : UPDATE tb_Company SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), LCASE(SUBSTRING(CompanyIndustry, 2))); Note that UPPER and UCASE do the same thing.
REGEXP is not case sensitive, except when used with binary strings.
http://dev.mysql.com/doc/refman/5.7/en/regexp.html
So with that in mind, just do something like this:
SELECT * FROM `users` WHERE `email` REGEXP BINARY '[A-Z]'; Using the above example, you'd get a list of emails that contain one or more uppercase letters.
71
For me this works and is not using a regexp. It basically compares the field with itself uppercased by mysql itself.
-- will detect all names that are not in uppercase SELECT name, UPPER(name) FROM table WHERE BINARY name <> BINARY UPPER(name) ; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
