best way to search a col with csv's?

2002-09-09 Thread Justin French
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

Re: best way to search a col with csv's?

2002-09-09 Thread Justin French
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