The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Search and Replace a string of text that includes quotes?
I am using the following query to find and replace text in a table due to a site change/redesign. I want to know how to use it to find text that includes quotes as well.
UPDATE articles SET article_header = REPLACE ( article_header, '74', '60'); I want to be able to do quotes too like: UPDATE articles SET article_header = REPLACE ( article_header, 'width="74"', 'width="60"'); But that is obviously not foing to work (i tried just to make sure and I need to know how to do it the correct way. |
#2
|
||||
|
||||
addslashes() and stripslashes() do the trick.
http://es2.php.net/addslashes http://es2.php.net/manual/en/function.stripslashes.php |
#3
|
|||
|
|||
And they go where? Can you format the query using the one I provided above?
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|