Re: Remove non-alphanumeric characters

[Guelphdad Lake]

probably because you did not change your delimiter. By default it is the ; and if you use that in the middle of a procedure or function mysql thinks you are done. so you can switch to something else like this:

DELIMITER $$

and until you type

$$

on a line by itself it will not break the function up and give you the error.

you can then switch back

DELIMITER ;

---------------
Guelphdad,
Moderator
forums.mysql.com