I use the following mysql query,

DELIMITER $$
DROP PROCEDURE IF EXISTS `allied`.`aboutus_delete`$$
CREATE DEFINER=`allied`@`%` PROCEDURE `aboutus_delete`(
IN p_Id int(11)
)
BEGIN
if exists(select aboutUsId from aboutus where aboutUsId=p_id and isDeleted=0)
   update aboutus set isDeleted=1 where aboutUsId=p_id
else
   select 'No record to delete'
END$$
DELIMITER ;

But i get this error when i execute it...

Error Code : 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 
'update aboutus set isDeleted=1 where aboutUsId=p_id
else
   select 'No record to' at line 6