View Single Post
  #23  
Old May 1, 2013, 03:59 AM
Cedille Cedille is offline
Senior Member
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,026
Default

Quote:
Originally Posted by Secret Squirrel View Post
Unfortunately, the Variations are a comma separated list containing multiple variations for a single artist. We can't match whole words there. We also don't want to partial match, becuase it'll generate a ton of false positives for simple small names. There may be some SQL tricks that could be used, but I don't know if they would totally alleviate this downside.
Well, then shouldn't we do some database normalization and create a new table for variations to make it to 1NF?

Also, I knew nothing about MySQL but I just installed it and the database seems to have a function that can match each segment split by a comma, like...

SELECT artist_name
FROM your_table
WHERE @parameter = artist_name OR FIND_IN_SET (@parameter, artist_variations)

Still, I'm not really a capable engineer and just don't get a point of the whole issue. If you think it's not so easy (for technical reasons or the lack of times), then it has to be hard.
Reply With Quote