SQL Comparison Operators Flashcards
(10 cards)
1
Q
=
A
Is equal to
2
Q
<>
A
Is NOT Equal to. != also works
3
Q
IN
A
Is equal to one of a set of values
4
Q
NOT IN
A
Is NOT equal to one of a set of values
5
Q
BETWEEN
A
Is within a range of numbers (Includes the end points)
6
Q
NOT BETWEEN
A
Is NOT within a range of numbers (includes the end points)
7
Q
LIKE
A
Matches a sequence of characters
8
Q
NOT LIKE
A
Does NOT match a sequence of characters
9
Q
IS NULL
A
Is equal to NULL
10
Q
IS NOT NULL
A
Is NOT equal to NULL
