Kim, See the Pattern Matching section of the manual at: http://www.mysql.com/doc/P/a/Pattern_matching.html
A "_" matches any single character, while a "%" acts as a wildcard match. -----Original Message----- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:36 AM To: <[EMAIL PROTECTED]> Subject: Re: Trapping for no user input in a query G'day Ron, all > Tailor your query to the request of your user(s). > if ($param1) > $sql .= "(ad_copy) against ('$param1')"; > if ($param1 && $param2) ˆˆˆˆˆ Thank you for your reply. If at all possible though, I'd like to do it from the mysql side rather than the php side of things. Is there such a thing as a wildcard character that can be used with a fulltext index that will return all rows? cheers kim --------------------------------------------------------------------- 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