MySQL Forums
Forum List  »  Newbie

Case Sensitivity in selects
Posted by: Tristan Gutsche
Date: August 04, 2005 08:28PM

Is there a function where i can set a search criteria to be case insensitive?
eg: select img_id, img_title from images where img_filename LIKE setCase(Insensitive, '%portugal%');

The filenames that are stored in the need to be case sensitive for file referencing, so i need to be able to match files & folder names like Portugal, portuGal, PORTUGAL etc etc.

Any ideas people might have?

Regards
Tristan

Options: ReplyQuote


Subject
Written By
Posted
Case Sensitivity in selects
August 04, 2005 08:28PM


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.