MySQL exclude row

Question

SELECT id,x,y FROM `chars` WHERE `mapa`='1'

how can i exclude row when id='3'

Answer 1

SELECT id,x,y FROM `chars` WHERE `mapa`='1' and id <> '3'

What is the data type of id though? If numeric you would want to use

SELECT id,x,y FROM `chars` WHERE `mapa`='1' and id <> 3

In MySQL you can also use != rather than <> but <> is ANSI and more portable.

Answer 2

SELECT id,x,y FROM `chars` WHERE `mapa`='1' AND `id`<>3