Hi all, I'm a bit of a searching newbie, What sql functions should I be looking at to return any rows containing a search phrase [eg 'Bob Smith'] from a column which may contain 1 OR MORE comma separated values?
Take this example table: id speakers date sample data: 1 Joe Blo, Jane Smith 2002-06-26 2 Barry Boo, Hank Smith 2002-05-17 A good start would be to return row id 1 given the search phrase "Jane Smith", but an even better solution would be to return would be if it returned row 1 (an exact match for "Jane Smith") followed by row 2 (a match on "Smith"). I'd like it all to be case insensitive. Many thanks in advance. Justin French --------------------------------------------------------------------- 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