On 1/16/15, Scott Robison <[email protected]> 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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
