The purpose of LIKE is to allow wildcard searching. I don't know offhand what the wildcard might be for MySQL (for Oracle it's '?' for a single character, or '%' for any number of characters).
So, in Oracle your WHERE clause could be any of: WHERE title LIKE 'Me%' WHERE title LIKE '?e, Myself %' WHERE title LIKE 'M?, My%' and you would get the record back containing a title of 'Me, Myself & Irene' Mike On 4/26/2005, "Jer" <[EMAIL PROTECTED]> wrote: > ><html><body> > > ><tt> ><BR> >Currently, I use LIKE in the query (i.e. WHERE title LIKE '$search').<BR> >I'm finding that that is too restrictive.<BR> ><BR> >For example, if someone were to search for the title "Me, Myself &<BR> >Irene", they would actually need to search for "me, myself & irene".<BR> >If they search for "me myself irene" or "me irene" or "me, myself and<BR> >irene", the search would come back with nothing.<BR> ><BR> >Is there a better way to search than using LIKE in the query?<BR> ><BR> ><BR> ><BR> ></tt> > ><br><br> ><tt> >Community email addresses:<BR> >� Post message: [email protected]<BR> >� Subscribe:��� [EMAIL PROTECTED]<BR> >� Unsubscribe:� [EMAIL PROTECTED]<BR> >� List owner:�� [EMAIL PROTECTED]<BR> ><BR> >Shortcut URL to this page:<BR> >� <a >href="http://groups.yahoo.com/group/php-list";>http://groups.yahoo.com/group/php-list</a></tt> ><br><br> > > > ><!-- |**|begin egp html banner|**| --> > ><br> ><tt><hr width="500"> ><b>Yahoo! Groups Links</b><br> ><ul> ><li>To visit your group on the web, go to:<br><a >href="http://groups.yahoo.com/group/php-list/";>http://groups.yahoo.com/group/php-list/</a><br>� ><li>To unsubscribe from this group, send an email to:<br><a >href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a><br>� ><li>Your use of Yahoo! Groups is subject to the <a >href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of Service</a>. ></ul> ></tt> ></br> > ><!-- |**|end egp html banner|**| --> > > ></body></html> > > > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
