possible to run an update query like this?

[AN-net]

UPDATE tablex SET field1=addslahes(field1);

[Andreas]

UPDATE tablex SET field1 = QUOTE(field1)

[AN-net]

would i be able to use addslashes inside of QUOTE() or does QUOTE() do that?

also how would i use htmlspecialchars_uni on it?

[Andreas]

addslashes() (http://www.php.net/manual/en/function.addslashes.php) is a PHP function, QUOTE() (http://dev.mysql.com/doc/mysql/en/string-functions.html#id2631984) a mySQL function.

htmlspecialchars_uni() is a vBulletin function.

[AN-net]

is there anyway i can use htmlspecialchars_uni() like that or would i have to call everything from table and then run an individual query for each?

[Paul M]

is there anyway i can use htmlspecialchars_uni() like that No, mysql will simply reject it as unknown. You would have to pull the records into an array, and then loop round them, converting the field in each row and updating the row back to the db.

[AN-net]

uh...ty all

[Marco van Herwaarden]

Maybe you can make it work using REPLACE().

But what are you trying to do? It makes no sense to me at all, if data is already succesfully inserted into the database, why do you want to run addslashes on it?