In message <[EMAIL PROTECTED]>, Mike Franks <[EMAIL PROTECTED]> writes > > >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).
It's % for anything, which doesn't really help the original question. > >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' He asked (and I missed it) >>If they search for "me myself irene" or "me irene" So your examples (and my original suggestion) would not work. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com 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/
