NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL is very smart - but why does this work?

Hans Zaunere hans at newyorkphp.com
Tue Dec 23 08:24:32 EST 2003


> SELECT * FROM archives WHERE genre_match = 2
> 
> it selects the rows whose genre_match column has the following info
> - 2
> - 2, 34, 96
> - 14, 2, 25

To be honest, I'm not sure why that works - but I wouldn't rely on it.
My initial guess is that some esoteric cast behavior is surfacing, since
that behavior is undocumented AFAIK.  I'd recommend doing it The Right
Way (tm).

H




More information about the talk mailing list