On 2018/01/05 10:14 AM, Rowan Worth wrote:
For this simple search it's easier to replace "NAME LIKE ?" with "instr(NAME, ?) > 0", unless you need case insensitive matching.
And in case you do wish for Case-Insensitive matching while using Rowan's method...
"instr(UPPER(NAME), UPPER(?)) > 0" (Or LOWER(), if you so wish). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
