Re: DB search and case sensitive comparison

> Now what I need to do is to ensure that the lookup_string is in the > useragent string and the CASE is the same: IE: Mozilla and not MOZILLA or > mozilla etc... Make the database do the work if possible. mysql> select * from a where a like '%MOZILLA%'; +---------+ | a | +---------+ | Mozilla | | MOZILLA | +---------+ 2 rows in set (0.00 sec) mysql> select * from a where a like BINARY '%MOZILLA%'; +---------+ | a | +---------+ | MOZILLA | +---------+ 1 row in set (0.00 sec) -- Postgresql & php tutorials http://www.designmagick.com/