<>

, !=

Syntax

MYSQL Copy

SELECT '.01' <> '0.01';
1
SELECT .01 <> '0.01';
0
SELECT 'zapp' <> 'zappp';
1

Contoh

Example

Not equal:

MYSQL Copy

SELECT '.01' <> '0.01';
1
SELECT .01 <> '0.01';
0
SELECT 'zapp' <> 'zappp';
1

Example 2

For row comparisons, (a, b) (x, y) and (a, b) != (x, y) are equivalent to:

MYSQL Copy

(a <> x) OR (b <> y)