My aim is to make a procedure that take a text -may contain idioms- as an input and it is output should be that text after replacing each idiom with it's meaning that their is a table called "idioms" which has two columns : the first is for idiom called "idiom" and the second is for idiom meaning and called "idiomMeaning" and this is my work till now :
delimiter //
create procedure idioms_search (in input text, out output text )
begin
WHILE EXISTS (SELECT idiom FROM idioms WHERE input LIKE CONCAT('%',@idiom,'%') ; )
SELECT REPLACE (@input,@idiom,@idiomMeaning ) INTO output;
end while;
end
//
delimiter ;
but the previous code contain errors , Any suggestions ?
و أرجو المساعده ضروري جدا جدا و ربنا يجزيكم خير مقدما