On 1/16/15, Scott Robison <sc...@casaderobison.com> wrote: > So the only remaining question is whether there is any functional > difference between the LIKE & GLOB SQL functions and the same named > operators (other than argument order)? Is there a reason to prefer one or > the other in SQL syntax?
They are aliases for one another. Syntactic sugar. You can see this by using EXPLAIN: .explain EXPLAIN SELECT * FROM sqlite_master WHERE name LIKE 'abc%'; EXPLAIN SELECT * FROM sqlite_master WHERE like('abc%',name); Both generate identical bytecode. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users