About 2/3 the way down the page at:
http://www.sqlitetutorial.net/sqlite-glob/ Get names without [1-9].
select trackid, name from tracks where name GLOB '*[^1-9]*';
Works properly in SQLiteMan and the SQLite Tutorial. ( Two
different products, not officially part of sqlite.org, I think, but use
the sqlite app.)
But not in sqlite3 3.15.1 and 3.16.1.
This works as expected in sqlite3 (3.15.1 and 3.16.1 :
select trackid, name from tracks where name not GLOB '*[1-9]*'; Gets
names without [1-9].
On 01/03/2017 07:37 PM, Richard Hipp wrote:
On 1/3/17, Ken Wagner <beauco...@gmail.com> wrote:
Hi SQLite,
In the SQLite3 Tutorial
What tutorial are you referring to?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users