• Courses
  • Code Compiler
  • Discuss
  • Pricing
  • Teams
Menu
+ 1

Negation of LIKE

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

likenegation
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

Often have questions like this?

Learn more efficiently, for free:

  • Introduction to Python

    7.1M learners

  • Introduction to Java

    4.7M learners

  • Introduction to C

    1.5M learners

  • Introduction to HTML

    7.5M learners

See all courses
Hot today
HELP ME LEARN
1 Votes
Please tell me about methods
1 Votes
Does anyone know how to go to another "page" on the same page using the HTML button tag?
2 Votes
Can I learn both graphic design and web development at the same time?
0 Votes
How do i learn php in here?
1 Votes
Hi everyone I hope you’re well
0 Votes
Running of python or js script (backend) and entering of html page by clicking SUBMIT button
2 Votes
Programming
0 Votes
How can I unenroll from a course I chose by mistake?
0 Votes
Losing hearts
0 Votes