MySQL Forums
Forum List  »  PHP

Re: Case sensitive queries and results
Posted by: Roland Bouman
Date: July 07, 2005 06:05AM

Hi, you could use the BINARY keyword in front of the comparison expression
like this:

SELECT file_name
FROM images
WHERE BINARY file_name like '%.jpg'

see: mysql manual 12.7.
Also Very instructive are the character set support chapters, chapter 10 in the mysql manual

Options: ReplyQuote

Written By
Re: Case sensitive queries and results
July 07, 2005 06:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.