On Wed, Jan 15, 2014 at 6:13 PM, Chris Swinefurth <[email protected]>wrote:
> The query: > SELECT terms.term, terms.id, terms.type, terms.product_id FROM terms > JOIN products ON terms.product_id = products.id JOIN > sub_categories ON products.category_id = sub_categories.id WHERE > terms.term LIKE 's%' collate nocase AND sub_categories.parent_id = 89133; > Thank you for the query. Can you also send the schema so that we can run it? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
