how to ensure comparison is case sensitive?
- by newguy
Hi there, 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
