4 ms·
> So even though the row has (from our perspective) a non-zero value, MySQL sees it as matching zero. What? Why does MySQL return the row with 'y' in it (in a
by jrochkind1 14y ago
> So even though the row has (from our perspective) a non-zero value, MySQL sees it as matching zero.
What? Why does MySQL return the row with 'y' in it (in a 'binary' column) when you ask for "where row = 0'? wtf is going on here?
That seems to be the real culprit here. I assume it's MySQL's 'helpful' conversion routines again, but I'm just assuming, I don't understand the details.