View Issue Details

IDProjectCategoryView StatusLast Update
0005474MMW v4DB/FileMonitorpublic2013-02-05 23:39
ReporterBex Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version3.1 
Target Version4.1 
Summary0005474: SQL wildcard characters used with LIKE don't work properly
DescriptionThese SQL statements don't return any result.
SELECT Artist FROM Songs WHERE Artist LIKE 'P%nk Fl%d'
SELECT Artist FROM Songs WHERE Artist Like 'P_nk Flo_d'

'%' only works if it's applied to the beginning or the end of the search string while '_' doesn't work at all.
Additional Informationhttp://www.mediamonkey.com/forum/viewtopic.php?f=6&t=38585
TagsNo tags attached.
Fixed in build

Activities

rusty

2009-04-06 17:53

administrator   ~0017400

--> 'immediate' for technical triage.

jiri

2009-04-07 18:28

administrator   ~0017440

I described some reasons for this in the forum post.