[SQL] Wrong comparing double column to string in MySQL

SELECT t.id, t.status, t.charges
FROM parcel AS t
WHERE t.user_id = 1
AND t.status = 'delivered'
AND t.charges = 'some string'
ORDER BY t.id DESC


i have this mysql query. it returns some result, but it should not. Because charges column is double and cant be equal to string

Continue reading...