i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out.

I need to update the column in all records of the table. It is full of single and double quotes. In the quarey i am trying to use update and it really fails badley.

I can update one row at a time but with 10K of records it will take some time.

Can i wrap this code in sometinge that will allow SQL not to go nuts when i try to use it as an update

OR

Can i edit one record and set all of the other records to equal the edited one

Hi,

How are you updating the table. 10K is not that big number when speaking about data bases.

If you are updating using php, you can use mysql_real_escape_string or addslashes to escape all the special characters like \, ' and ".