Is there any way that I could use trigger instead of check? like I have
CREATE /*!50017 DEFINER = 'root'@'localhost' */ TRIGGER
testBEFORE UPDATE ON
applyFOR EACH ROW BEGIN IF NEW.cname = "hi" THEN
SET NEW.cname = "hello"; ELSE
RETURN 1; END IF; END; $$
but return 1 doesn't work. Is there anyway that I can prevent the query from executing?