Why is this mysql syntax incorrect

Question

I execute the following mysql query and get an error with the wrong syntax.

SELECT COUNT(*) FROM PS.INFO WHERE IPADDRESS='1.1.1.1' AND ID='YYY' AND (TYPE='PAID' 0R  TYPE='FREE') AND EXPIRYTIME IS NULL;

Please help me with the correct syntax?

+3

ihavprobs Jun 14 '11 at 14:12

3 answers

TYPE = 'PAID' 0R TYPE = 'FREE'

OR

seems to have zero instead of O

+5

Jaydee Jun 14 '11 at 14:14

A mistake always tells you where to look. In this case, he says "about" 0R ... "

And of course, that zero, not O. It must be a word OR.

+4

Voteydisciple Jun 14 '11 at 14:14

Joachim sauer · Accepted Answer · 2011-06-14T14:13:56+0000

Wrote 0R(zero-R) instead of OR(OR).