nevermind, I find what I needed:
http://www.joegrossberg.com/archives/000933.html
[EMAIL PROTECTED]
sign.co.uk To: [EMAIL PROTECTED]
cc:
06/08/2004 12:02 Subject: [ cf-dev ]
Find-and-Replace in SQL
Please respond to dev
How could I do this in MySQL, just using a query:
Find all instances of <h1> (for instance).
Change them to <h2>.
The only way I can think of is to query the database for LIKE '%<h1>%';
then loop through the results with Coldfusion, doing a RegEx to replace the
bits you want to change, then perform another query within the loop to
update each record. But is it possible to do this just using sql?
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
