Negation of LIKE | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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 Answer
+ 8
SELECT * FROM TABLE WHERE COLUMN NOT LIKE '%a';
19th Jan 2018, 1:11 AM
Hatsy Rei
Hatsy Rei - avatar