存储过程创建失败
CREATE PROCEDURE sp_select_filter(IN sp_name VARCHAR)
-> BEGIN
-> IF sp_name IS NULL OR sp_name = '' THEN
-> SELECT * FROM imooc_goddess;
-> ELSE IF LENGTH(sp_name) = 11 AND SUBSTRING(sp_name,1,1) = 1 THEN
-> SELECT * FROM imooc_goddess WHERE mobile = sp_name;
-> ELSE SELECT * FROM imooc_goddess WHERE user_name LIKE CONCAT('%',sp_name,'%');
-> END IF;
-> END IF;
-> END
一直提示错误,请哪位帮忙看看?
