Hi All I am making a search program. I am looking for a query. I want to allow the user to search "Any" or "All". Anyhow, suppose the database contains the following
Author -------------------- | Rim Torus | | Jerry Pal Deprado | | Roan P. Classy | ------------------- If the user searches for Rim Torus, I am though. But how to allow results if the search is "Jerry Classy", saying Any should match and have both second and third rows returned? Help is appreciated. Thanks Aman _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --------------------------------------------------------------------- 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
