Re: Search tough question

2002-01-04 Thread Colin Faber
How about using a fulltext index on the field then using a LIKE wild card limiting. Example: SELECT blah FROM tbl WHERE MATCH (ftindex_col) AGAINST ('Neil Young') AND col LIKE "Neil Young%"; This will find only items with Neil or Young AND ^Neil Young, Playing around with this formula will al

Search tough question

2002-01-04 Thread Stephen Griffiths
Hi people, I think this is a tough question, or it could be pretty easy. I have this text file which has a line that has 'someartist - some song'. I use php to open the file and read the line and I now pass this line into the mysql query. (lets use $string as the var). Here's the problem. I have