SELECT *,CAST when likemsg.msgid = '' THEN 1 from msg LEFT JOIN likemsg ON msg.id=likemsg.msgid
Error Show :
Error
SQL query: Documentation
SELECT * , CAST
WHEN likemsg.msgid = ''
THEN 1
FROM msg
LEFT JOIN likemsg ON msg.id = likemsg.msgid
LIMIT 0 , 30
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'when likemsg.msgid = '' THEN 1 from msg LEFT JOIN likemsg ON msg.id=likemsg.msgi' at line 1
What I have tried:
SELECT *,CAST when likemsg.msgid = '' THEN 1 from msg LEFT JOIN likemsg ON msg.id=likemsg.msgid