[PHP] DB search and case sensitive comparison

2008-07-15 Thread Angelo Zanetti
Hi all, I have a question and I can't seem to get around the problem or finding a total solution. I have a DB with a list of entries, one of the tables has fields and one of the fields is called the lookup_string field. This field is used to checkup values when users enter the site (explained

Re: [PHP] DB search and case sensitive comparison

2008-07-15 Thread Chris
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 | +-+ |