----- Original Message ----- From: "MikeParton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 8:21 PM Subject: [PHP-INST] Search Field
Environment: Win NT 4.0 SP6a Apache 2.0.36 MYSQL 4.0.1a PHP 4.2.1 I'd like to create a search capability against a MySQL database that will allow users to do keyword searches, entering one OR MORE keywords in the text box. Thoughts on the most effective way to do this? Would this be handled by the sql where the statement is something like: $keywords=$selection //equal to the keywords entered by the user in the text box named "selection" SELECT column1, column2 FROM table WHERE text=$keywords What do I need to do to make sure the query searches for ANY of the keywords entered into the text box? TIA Mike SQL,query,MySQL --------------------------------------------------------------------- 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
