Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MarkCoutinho]

Hi all,

First of all: I've checked pretty thoroughly in the MC Wiki, but I can't find the answer there. So...

I want to know how I can combine several search items in 1 smartlist.
Particularly this one: search within the lyrics to all the songs that have the words "fountain" and "beauty" and "everywhere" in it.

The wizard doesn't help me with that either.

So what would the search be in TEXT-format?

Thanks!

[marko]

You can do like this:

Code: [Select]

([Lyrics]="fountain" or [Lyrics]="beauty" or [Lyrics]="everywhere")

or like this:

Code: [Select]

[Lyrics]="fountain","beauty","everywhere"

Does that help?

[MarkCoutinho]

Thanks so much, Marko, but that's not exactly what I meant.
The result I want is songs which have ALL the words in it. So the 'or'-'or' option doesn't work.
I thought your second suggestion would be the 'and'-'and' option, but that doesn't do it either.

For instance. I know the lyrics of Alphabet St. by Prince have the words "Tennessee" and "cruel" and "down" in them.
- [Lyrics]="Tennessee" comes up with 17 hits (one of them being Alphabet St.)
- [Lyrics]="cruel" comes up with 100 hits (one of them being Alphabet St.)
- [Lyrics]="down" comes up with 3925 hits (one of them being Alphabet St.)

Now:
- [Lyrics]="Tennessee","cruel" comes up with 116 hits
- [Lyrics]="Tennessee","cruel","down" comes up with 4000 hits

whereas in the latter one I should expect just Prince's song (or maybe one more by coincidence). And that's what I want to achieve.

Hope you can help me on this one.

I

[mark_h]

This is a simple AND query.  Track has "this" AND "that" AND "the other" in the lyrics.

Code: [Select]

[Lyrics]="Little" [Lyrics]="Red" [Lyrics]="Corvette"

[MarkCoutinho]

That's it! Thanks, Mark!