[SOLVED] WHERE conditional syntax?

[adamcannon]

Hello,

 

Does anybody know why this WHERE statement doesn't work correctly?

 

SELECT * from main WHERE (field=1 || field=2) && column=3

 

It seems this type of conditional works fine in PHP/Perl but not in MySQL.

[bubblegum.anarchy]

The above form of conditional syntax should work fine in MySQL though most use `OR` and `AND` - what results are you getting?

 

[bubblegum.anarchy]

Just in case those field names are not just examples, try this instead:

 

SELECT * FROM main WHERE (`field`=1 || `field`=2) && `column`=3

 

[adamcannon]

The above form of conditional syntax should work fine in MySQL though most use `OR` and `AND` - what results are you getting?

 

 

I'm getting:

 

Empty set (0.00 sec)

 

The statement works if I remove the AND part of the conditional.  Must be something small I'm missing.

[adamcannon]

I just sort of figured out the problem.  The actual statement includes a NULL in one of the conditionals and I think mysql has syntax for tackling this.  Thanks.