how to convert varchar to int

See more:

MySQL

hi
i have create a store procedure in MySql and in that i m calling a parameter
which is in varchar and i want to convert it into integer

my store proceducre is

create procedure abc
(
search varchar(10)
)
begin
select id,name,city from table1
where id=cast(search as int);
end

but the cast function is giving error
and isnted of cast i have also used convert but it is also not working
convert(int,search);

pls help me ...

Thanks

Regards
Sagar Khairnar