Hello.
You may use something like:
prepare stmtl from 'select * from ren1 where yo like concat("%",?,"%")';
set @a='1';
execute stmtl using @a;
Nathan Coast <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to modify parameters passed to prepared statements?
>
> e.g.
>
Hi,
Is it possible to modify parameters passed to prepared statements?
e.g.
select ...
where username like '%?%'
I'd like to put wildcard chars '%' on either end of a parameter. Is
this legal? or do I have to modify the parameter before passing it to
mysql.
thanks
Nathan
--
Nathan Coast
Ma