MySQL Forums
Forum List  »  PHP

like (non-case-sensitive)
Posted by: Andrew Vandever
Date: April 25, 2006 06:45PM

I'm trying to set up a search function in a PHP-based, blog-like app, and want to make the search not be case-sensitive. The line currently reads:
WHERE pst_sbjt regexp 'SearchString' OR pst_cont regexp 'SearchString'
I tried before:
WHERE pst_sbjt like'%SearchString%' OR pst_cont like'%SearchString%'
both return case-sensitive results. How do I make it non-case-sensitive?
Is there a reference somewhere for all the %-like modifiers available?
Thanks.

Options: ReplyQuote


Subject
Written By
Posted
like (non-case-sensitive)
April 25, 2006 06:45PM


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.