Use FullText indexing or a REGEXP. Brian.
----- Original Message ----- From: "Robert Macwange" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 9:18 AM Subject: Exact word search | Hello y'all, | | I guess this is easy, but it is defeating me. | I am having a problem with this query: | | $keyword = "search"; | SELECT * FROM table WHERE field LIKE '%$keyword%' | | The problem is I don't want "sear" or earch but exactly "search". | | What am I missing? | | .......... | Regards, Robert (Newbie) | | | | --------------------------------------------------------------------- | Before posting, please check: | http://www.mysql.com/manual.php (the manual) | http://lists.mysql.com/ (the list archive) | | To request this thread, e-mail <[EMAIL PROTECTED]> | To unsubscribe, e-mail <[EMAIL PROTECTED]> | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
