Simple sql query return zero row

Question

My query :

SELECT * FROM game_tbl WHERE ( `player_o` = 1 OR `player_x` = 1 ) AND ( `player_o` = NULL OR `player_x` = NULL )

game_tbl :

use: mysql

and the result is zero rows, i want the 'game1'. Well i guess i can use other query but, important to my to understand right my wrong sql syntax, thank you all

Darshan Mehta · Accepted Answer · 2017-05-14 10:21:22Z

2

Try using IS NULL instead of = NULL, e.g.:

SELECT * 
FROM game_tbl 
WHERE (`player_o` = 1 OR `player_x` = 1) AND (`player_o` IS NULL OR `player_x` IS NULL)

Here's MySQL's documentation on working wiith NULL values.

To test for NULL, use the IS NULL and IS NOT NULL operators.

You cannot use arithmetic comparison operators such as =, <, or <> to test for NULL.

answered May 14, 2017 at 10:21

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mayan anger Over a year ago

So embarrassing you'r right tank you for you fix my syntax

Collectives™ on Stack Overflow

Simple sql query return zero row

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related