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

how can i exclude row when id='3'

Ghandhikus
  • 839
  • 2
  • 9
  • 12

2 Answers2

6
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.

Community
  • 1
  • 1
Martin Smith
  • 438,706
  • 87
  • 741
  • 845
3
SELECT id,x,y FROM `chars` WHERE `mapa`='1' AND `id`<>3