Member Avatar for fclanton

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

  • 3 Contributors
  • 2 Replies
  • 86 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by nav33n
Member Avatar for kb.net

Hi,

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

Member Avatar for nav33n

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.