+ 1

Negation of LIKE

How find records which don't end for "a" for example?

18th Jan 2018, 10:59 PM
Mati Wojtania
Mati Wojtania - avatar
1 Odpowiedź
+ 8
SELECT * FROM TABLE WHERE COLUMN NOT LIKE '%a';
19th Jan 2018, 1:11 AM
Hatsy Rei
Hatsy Rei - avatar