• 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
Functions in python
2 Votes
How to make a playground
1 Votes
Html 5 document question
1 Votes
𝙵𝙸𝙽𝙳 𝚃𝙷𝙴 𝙸𝙽𝙿𝚄𝚃 𝙾𝙵 𝚃𝙷𝙴 𝙿𝚁𝙾𝙶𝚁𝙰𝙼
1 Votes
Python
0 Votes
Can someone explain inline and block elements please
0 Votes
Actual Artificial Intelligence
0 Votes
Need friends
0 Votes
MASS N NUMBER OF OBJECT DELETION FROM A CLASS
0 Votes
Schuffle a list
0 Votes