On 7 Aug 2011, at 12:17pm, Alexey Pechnikov wrote: > Is it possible to support construction like to > > where x IN "1 2 3"
How does this differ on the IN operator ? <http://www.sqlite.org/lang_expr.html#in_op> For example, SELECT * FROM cars WHERE cars.name IN ('Corolla', 'Fiesta') > There are a lot of situations when is very useful to store list of > identifiers in table field. SQLite supports this: SELECT * FROM cars WHERE cars.name IN (SELECT names FROM models WHERE type='obsolete') or even SELECT * FROM cars WHERE cars.name IN models.names Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
