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