I know that function in php, but I generate sql from a sql queries in order
to export some data
from on database to another.
I make something like that :
select concat('INSERT INTO links VALUES(NULL,"99","',link.about,'","',
....
from
links,
...
this queries gives me sql insert command.
but in some field eg : link.about there is " char but " is my string
delimiter, so in that particular case
where about field has " on it the string is prematurly terminated and gives
me wrong sql insert.
i d like to have a mysql function to escape char in field about so i can
make rigth insert in all case.
I d like to avoide addition scripting langage, sql is enough ?
Thanks.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
