Quote:
Originally Posted by Secret Squirrel
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.