how to ensure comparison is case sensitive?

Question

im trying to do a comparison in MYSQL but wish for it to be case sensitive

ex:

$userID="test"
$q = db_query("select * from users where user_id = '" .  $userID  . "'");

In DB:

userid = "TEST"

Ho do i go about making sure the mysql query does not return TRUE for this query as the userid varialbe doesnt match the case of the userid in the database

thanks

possible duplicate of [case insensitive for sql LIKE wildcard statement](http://stackoverflow.com/questions/2876789/case-insensitive-for-sql-like-wildcard-statement) — OMG Ponies, Jun 09 '10 at 19:22

Raj More · Answer 1 · 2011-03-08T15:27:17.460

3

You can force to compare with case sensitivity using COLLATE

http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html

You can also use BINARY

SELECT * FROM users WHERE BINARY user_id = '%John%'

edited Mar 08 '11 at 15:27

answered Jun 09 '10 at 19:18

Raj More

47,048
33
131
198

Mads Mogenshøj · Accepted Answer · 2010-06-22T13:41:00.103

0

The MySQL manual explains possible solutions quite well.

edited Jun 22 '10 at 13:41

answered Jun 09 '10 at 19:19

Mads Mogenshøj

2,063
1
16
23

You could and should at least still give a quick explanation on the solution – Herr Mar 08 '11 at 09:56

how to ensure comparison is case sensitive?

2 Answers2