I have a table with a filed Customers defined as int(10)
I have the following query:
SELECT * FROM 'table' where
Customers = 'a'
This query returns all entries which have 0 in this field, BUT a is not equal to 0 as we know?
Also I can use any string, not only 'a'.
BUT on other database the same query works as expected. It doesn't return any entries.
Any explanation ?