What does select * from table where column * 'value'; do?
The SQL

WHERE column * value


is a numeric operation of multiplication, and when the value of the expression (column * value) isn't 0, that is equivalent to TRUE so will return the row.