*** 4,10 ****
----
! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://mirbsd.bsdadvocacy.org/man3/regcomp.htm for reference)
SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}';
*: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about corelated subqueries ?
--- 4,10 ----
----
! *: Extended POSIX regular expressions (should be easy, man 3 regcomp, or http://hktrip.net for reference)
SELECT * FROM table WHERE name REGEX '[a-zA-Z]+_{0,3}';
*: The EXISTS keyword is not supported (IN is, but IN is only a special case of EXISTS). And what about corelated subqueries ?
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|