07-21-2016, 03:30 AM
Thank you, Mike.
It took me some time to recognize that I have to make the two queries step by step, but something went wrong.
As I did not use commas to separate keywords, I first tried the two simple queries. But they created genres for nearly all songs with incredible many genres (see picture attached).
So I replaced the database by my backup and tried the more complex queries.
The complex queries created more new genres (from 46 to 101) including one "<blank>" genre.
Several genres got doubled "Med.", "Med." on songs.
A Song with the keyword "Bright Latin or Swing" at the end had the following genres:
"Bright", "BrighT", "Bright Latin", "Bright Latin or Swing", "Latin", "Swing", "<Blank>"
So the query created from every word (instead of "or") and every combination a genre and added this to the song.
I am not used with SQL so I don't know how to modify the query.
If everything would work well it would be good to have an additional query to delete all "keywords". I think that is easy for you unfortunaly not for me.
Thank you
Paul
It took me some time to recognize that I have to make the two queries step by step, but something went wrong.
As I did not use commas to separate keywords, I first tried the two simple queries. But they created genres for nearly all songs with incredible many genres (see picture attached).
So I replaced the database by my backup and tried the more complex queries.
The complex queries created more new genres (from 46 to 101) including one "<blank>" genre.
Several genres got doubled "Med.", "Med." on songs.
A Song with the keyword "Bright Latin or Swing" at the end had the following genres:
"Bright", "BrighT", "Bright Latin", "Bright Latin or Swing", "Latin", "Swing", "<Blank>"
So the query created from every word (instead of "or") and every combination a genre and added this to the song.
I am not used with SQL so I don't know how to modify the query.
If everything would work well it would be good to have an additional query to delete all "keywords". I think that is easy for you unfortunaly not for me.
Thank you
Paul
---------------------------------------------------------
13" - Point of View POV_TAB-P1325, Android 4.1.1
13" - Point of View POV_TAB-I1345, Android 5.1.1
Microsoft Surface Pro 4; Windows 10
Phone: Motorola Moto G3, Android 6.0
13" - Point of View POV_TAB-P1325, Android 4.1.1
13" - Point of View POV_TAB-I1345, Android 5.1.1
Microsoft Surface Pro 4; Windows 10
Phone: Motorola Moto G3, Android 6.0