Is this possible using the music selections...?

[Guest]

I have a few (cough cough) karaoke song in my DB. I decided to try to clean things up a little. Now everything is done except one problem. There are many artist that have a "The" at the begining of the artist name, unfortunatly those same artists also have song in which the "The" is missing.

I was wondering if there is a way to isolate all the ones missing the "The", using the ones with the "The" as comparision? Or anything that would permit me to isolate the ones missing it so I could add it..... I've tried my hand at using the selections for it, but no luck.

Doing it all manually is an option but not one I really want to do......

If anyone can think of a solution using any other app(s), I am eagerly listening.

[Service-Team]

This works with a using SQL Expression as the field and leadartistname IN (SELECT SUBSTR(leadartistname, 5, 999) FROM tracks WHERE leadartistname LIKE 'the %') as the value:

missing-the.png (292.2 KiB) Viewed 1876 times

... seems as if we also have some things to clean up

Best regards,
Your Siverjuke-Team

[Guest]

Hmm, NICE.
The SLQ Expression stuff seems to be in a foreign language. I'm gonna hafta try to be more fluent!!
Thanks SJ-Team

[Service-Team]

Well, SQL is SQL
If you are interested in learning this language, see eg. http://www.w3schools.com/SQl/default.asp

However, for Silverjuke, mostly the WHERE-conditions are useful, and, however, for most stuff you won't need SQL at all.

Best regards,
Your Silverjuke-Team

[Guest]

Thanks, will have a look.