On 05/15/2011 09:14 AM, Igor Tandetnik wrote:
> Pontiac<pontia...@gmail.com> wrote:
>> On 05/13/2011 03:15 PM, Trevor Borgmeier wrote:
>>> SELECT categories FROM myTable WHERE (","||categories||",") LIKE "%,7,%";
>> Careful with how you have your like. As an added bonus, if you were to
>> hunt for category 1, your statement would be LIKE "%,1,%" which would
>> return no results.
> Will too. Note what's on the left hand side of LIKE.
My bad. Eyes skipped right over that.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
