Hi all, I've been playing with Fulltext, and for a while there, I though it was a good solution, but I do need something that doesn't use stopwords... For example, if Bob Smith was the primary speaker at MOST conferences, then I'd need a search for Bob Smith to return accurate results, not be ignored just because he's popular :)
I'd rather strip out some noise words like 'a' & 'the' BEFORE using the search term in a query, in order to maintain control. Any ideas? Justin on 09/09/02 4:35 PM, Justin French ([EMAIL PROTECTED]) wrote: > 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 > --------------------------------------------------------------------- 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
