ginoplusio on 10/20/12
Last Edited at 10/20/12 08:14am
SELECT id,title, (CASE date WHEN '0000-00-00' THEN '' ELSE date END) AS date FROM your_table SELECT id,title, (CASE status WHEN 0 THEN 'open' WHEN 1 THEN 'close' ELSE 'standby' END) AS status FROM your_table
URL: http://www.barattalo.it/2012/10/19/13-mysql-tips/
Report this snippet Tweet
Comment:
You need to login to post a comment.