I have SQL query for voting, to check if vote alredy exists, but it keeps giving me syntax error near
IF EXISTS (SELECT * FROM `votes` WHERE `id` = 298 AND `author` = 'noo
Subquery itself runs fine.
IF EXISTS (SELECT * FROM `votes` WHERE `id` = 298 AND `author` = 'noob') THEN
'exist'
ELSE
INSERT INTO `votes`(`id`, `author`, `type`, `value`) VALUES (298, "noob", "upvote", 1)
'upvoted'
END IF
Thanks for help
Aucun commentaire:
Enregistrer un commentaire