Is this a mysql bug?

fouss · May 14, 2012, 1:30pm

This is my SQL query




SELECT * 

FROM `article` 

WHERE publie =1

But it gives me the result with publie value=0

I did it several times but the same probleme.

Any idea?

mustafa555 · May 14, 2012, 1:42pm

check for "publie" in the DB type.

Is publie is int ?

Thanks,

Mustafa

fouss · May 14, 2012, 1:51pm

Solved!

It was enum type so I added cote like this




SELECT * FROM `article` WHERE publie ='1'

thx!