How to use case sensitivity in instr() in MySQL?
Possible duplicate: How to apply wildcard in instr() in MySQL?
The possible duplicate linked shows a query which is exactly like my current one sort of. However, I cannot find a way to make it a case sensitive match. :\
SELECT COUNT(*) FROM users WHERE INSTR(flags, 'T') > 0;
I get a count of 46 which is obviously wrong. It's counting every instance "T" in flags whether it's upper- or lower-case.
It works as according to the MySQL documentation. I found something in the MySQL docs that said to put an "@" symbol on a variable to make it a case sensitive match. However, I tried this on the @'T' to form the following query:
SELECT COUNT(*) FROM users WHERE INSTR(flags, @'T') > 0;
I get a count of zero.
Could anyone shed some light on this for me? :)
Forgot to mention, sorry. I also tried a
LIKE '%T%' as the where-clause, which still failed and returns the same as
(INSTR(flags, 'T') > 0);
SELECT binary 'AKkRBbagSsPpCtmxeGhUX' LIKE '%T%';
produces '0', as expected. According to the String Comparison documentation, LIKE performs a binary (thus, case-sensitive) comparison if either of its operands are binary.
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]