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 an Artist field that has a few entries like 'Artist a', 'artist b', 'foobar asrtist' blah blah. What I want to is the mysql to search through the artist field to find the closest match to $string. For example, if my Artist field contained 'Neil Young' and $string contained 'Neil Young - Let's Roll', it would have 'Neil Young' as the closest match in it's result set. E-mail me if you need more info or don't get what I'm asking. Hopefully you people can help me. :) If isn't "SELECT * from Artist_tbl WHERE Artist LIKE '%$string%"; either ;) Hope someone can understand my gibberish and help me out :) Thanxs -- Steve Griff mailto: [EMAIL PROTECTED] | http://www.stevegriff.com Live CDR Trading: Beck, Neil Young, Frank Zappa, Radiohead, Ry Cooder, Bowie, Xtc, Nirvana & More. E-Mail me for any music trade! --------------------------------------------------------------------- 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