sql for changing a single term

18th Sep 2004

I'm no expert when it comes to sql, so this handy little snippet I recently used to add paragraph tags to my blockquotes in order to validate my lowercase blogmarks as XHTML Strict may be simple/basic for some readers:update table_name set column_name =replace(column_name,'<blockquote>','<blockquote><p>'); This added p tags after the blockquote tags. I repeated the sql for the closing p tags to sit before the closing blockquotes by adding the closing slashes.