[url=http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=38585]SQLite LIKE matching characters don't work as they should[/url]

SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%10%' AND Songs.SongPath LIKE '%The%' AND Songs.SongPath LIKE '%Blues%' AND Songs.SongPath LIKE '%Brothers%' AND Songs.SongPath LIKE '%B%' AND Songs.SongPath LIKE '%Movie%' AND Songs.SongPath LIKE '%Box%' AND Songs.SongPath LIKE '%Car%' AND Songs.SongPath LIKE '%Blues%'

I'm working around this issue now with syntax like this...

[code]SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%10%' AND Songs.SongPath LIKE '%The%' AND Songs.SongPath LIKE '%Blues%' AND Songs.SongPath LIKE '%Brothers%' AND Songs.SongPath LIKE '%B%' AND Songs.SongPath LIKE '%Movie%' AND Songs.SongPath LIKE '%Box%' AND Songs.SongPath LIKE '%Car%' AND Songs.SongPath LIKE '%Blues%'[/code]
It seems to work ok, although obviously the logic is a little different now, as the order of the parts is no longer correct.

But this definitely used to work, this script would never have worked without that, nor would my RecreateM3U, or quite a few of my other scripts!

[quote="jiri"]MMW5 (rather early in the development atm)[/quote]
:D

The currently Like implementation hasn't been changed for quite a long time and yes, it's a little limited. We don't plan to change it atm, but MMW5 (rather early in the development atm) will probably support regular expressions, i.e. will be much more powerful.

Jiri

SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%\10%The%Blues%Brothers%B%Movie%Box%Car%Blues%'

SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%Blues%'

My "ImportM3U" script works by checking the path of tracks in the library against the paths in an M3U file. For example, this...

[code]SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%\10%The%Blues%Brothers%B%Movie%Box%Car%Blues%'[/code]
...which should match with the path "[b]:\Music\The Blues Brothers\Briefcase Full Of Blues (1995)\10_The Blues Brothers_'B' Movie Box Car Blues.mp3[/b]". This definitely used to work, but for some reason, it no longer is in the latest version (and maybe a few versions now). However, if I run this command...

[code]SELECT Songs.ID FROM Songs WHERE Songs.SongPath LIKE '%Blues%'[/code]
...then it does find this track. It looks like you can only have two "%" characters in a LIKE!? :-?