I have been looking through the mailing list archives but I can seem to find a straight forward answer anywhere.
I have a MySQL table with a variety of text columns I would like to search. Pretty basic... A web search form returning the users input $keywords. Some type of relevance system would be great but it is not necessary. I have been messing around with LIKE, IN and to an extent REGEXP but I can't seem to get it to work. For example if the user inputs "red fire engines" I would like to query across "colour", "type" and "description" for each of the words. Can this easily be done? Do I need to create a "keywords" column each time I update any of the keyword columns I would like to search? Any help would be greatly appreciated. I am also on digest mode so please CC me if you reply to the list or via versa. Thanks, Dan --------------------------------------------------------------------- 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