sql_lite: If query is not a LIKE % search use = .

[vlc] / modules / media_library / sql_search.c

diff --git a/modules/media_library/sql_search.c b/modules/media_library/sql_search.c
index d69d3d18a1823b36794f41a2528b48e7c4b62715..5a0848b0a397fd12948640770edac4258493381a 100644 (file)
--- a/modules/media_library/sql_search.c
+++ b/modules/media_library/sql_search.c
@@ -887,7 +887,8 @@ case casestr:                                                                 \
     assert( tree->comp == ML_COMP_HAS || tree->comp == ML_COMP_EQUAL          \
         || tree->comp == ML_COMP_STARTS_WITH                                  \
         || tree->comp == ML_COMP_ENDS_WITH );                                 \
-    *ppsz_where = sql_Printf( p_ml->p_sys->p_sql, "%s LIKE '%s%q%s'", fmt,    \
+    *ppsz_where = sql_Printf( p_ml->p_sys->p_sql, "%s %s '%s%q%s'", fmt,      \
+        (ML_COMP_EQUAL)?"=":"LIKE",                                           \
         tree->comp == ML_COMP_HAS                                             \
         || tree->comp == ML_COMP_STARTS_WITH? "%%" : "",                      \
             tree->value.str,                                                  \