> 1 NULL 2011-07-01 00:00:00 > 323031312d30372d30312030303a30303a3030 > 3 2011-07-01 00:00:00 NULL > 323031312d30372d30312030303a30303a3030 > > > > I need that last column to be 2011-07-01 and I need both rows. Any > idea why max(coalesce()) doesn't work? I'm running MySQL 5.1
There's something going on with your encoding - '323031312d30372d30312030303a30303a3030' is your date string encoded as a series of hex values. -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
