On 1 Feb 2010, at 9:49pm, flakpit wrote: > To to get columns that begin with a number range or any number, I would use > in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > > This obviously doesn't work in sqlite and I have been searching for an > equivalence.
SELECT * FROM mytable WHERE myfield >= '0' AND myfield < ':' If you have an index on 'myfield' this will be very fast. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
