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.
>
> 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
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
