How to use paramerters in stored procedures

[DGeorgie]

Hi,

I am trying to do something like this in MySQL 5.0

create function myfunc(param_name varchar(100)) returns int
begin
        ......

        if exists(select 1
                from my_table
                where name = param_name) then
                return -1;
        end if;
        .....
end;

The condition is never true. What am doing wrong?

Thanks,

Dimitar 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]