sqlite - SQLite 中的 LIKE 和 GLOB 有什么区别？

Question

下面查询有什么区别？

FROM COMPANY WHERE ADDRESS  GLOB '*-*';
FROM COMPANY WHERE ADDRESS  LIKE '%-%';

我知道与 LIKE 运算符不同，GLOB 区分大小写。这是唯一的区别吗？

Answer 1

documentation说:

The GLOB operator is similar to LIKE but uses the Unix file globbing syntax for its wildcards. Also, GLOB is case sensitive, unlike LIKE.

就是这样。