3 ms·
I only recently learned that LIKE also supports something vaguely similar to regex character classes: SELECT * FROM customers WHERE company_name LIKE '
by krylon 8y ago
I only recently learned that LIKE also supports something vaguely similar to regex character classes:
SELECT * FROM customers
WHERE company_name LIKE 'foo[lt]'
will only return customers whose company_name is 'fool' or 'foot', while
SELECT * FROM customers
WHERE zipcode LIKE '12[^30]45'
will return customers whose zipcode is LIKE '12_45', except '12345' and '12045'.