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.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
