Print

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

[sherbs]

How do I search for a song title containing a particular word?

If I'm looking for song titles containing the word 'car', for example, how do find them without seeing names containing carry, careful etc as well?

Thanks.

[Matt]

[car]

You might also try the wizard in the search box for advanced searches.

[MrC]

Matt - this doesn't work well.

Searching for non, for example, returns things like:

  Donna Non Vidi Mai (Manon Lescaut)
  17th Century Canon

That's good.  But searching for [non] returns nothing.

Searching " non " does work, but of course, only if non is in the middle surrounded by spaces.

[MrC]

In lieu of additional responses, if you want to search just the Name field, for an exact term, you can use an expression search:

  [=regex([Name], \bCAR\b)]=1

Replace CAR with the exact word you want, and paste the expression into the search box.  The expression as written is case-insensitive, but can be modify to honor case.

[Matt]

Sorry, I mispoke above.

[car] returns only exact matches of car

To search for words inside a string, you'd have to do something more complex, like:
[car "," car "," car]

I'm trying to think if there's some more natural syntax we could offer for this.

[Matt]

In a coming build of v17, you can do this:
^car

From the history:
NEW: The search language supports putting a hat in front of a keyword to do word matching (so ^car matches "Car Blues" or "My Car Broke" but not "Carolina on My Mind").
Changed: Hat is an escaped character in the search language, so you must use /^ to search for a literal hat.

[MrC]

Works pretty well.

^car

returns 12 results, where the expr. above returns 13.  The difference:

  Ding-Dong Daddy of the D-Car Line

Yet, ^car (and the expr) does find:

  Car/Foot Chase

so it seems there are some non-alpha chars that are considered part of the word, some that are not.

[sherbs]

Thanks for the replies.

Due to being on MC15, looks like I'll have to go with

To search for words inside a string, you'd have to do something more complex, like:
[car "," car "," car]

This seems to work but using name=[...] includes Album titles that include the word. Any way to confine it to just song titles?

Thanks.

[MrC]

Due to being on MC15, looks like I'll have to go with

I'm sorry Sherbs - I entirely overlooked the forum name you posted this under, so misguided you.

Well, on the bright side, now there's yet another feature awaiting your update to MC17.  :-)