Hi
Does anyone know how can I replace the "comment_author_url" field from all comments by running a SQL query?
for example if this field is http://google.com to replace it with "" (empty string)
views:
10answers:
1
+2
A:
Use:
UPDATE your_table
SET comment_author_url = ''
WHERE comment_author_url = 'http://google.com'
OMG Ponies
2010-07-13 22:45:09
thank you. it works :D
Alex
2010-07-13 22:50:19
Nice answer. Quick and simple. Would make for a neato plugin with some regex matching. ;-)
hsatterwhite
2010-07-14 12:55:09
@hsatterwhite: Swap `WHERE comment_author_url = ...` with `WHERE comment_author_url REGEXP ...` - there's [more info on MySQL's regex support in this documentation link](http://dev.mysql.com/doc/refman/5.1/en/regexp.html).
OMG Ponies
2010-07-14 15:37:25
Thats pretty sweet. Thanks again for the link!
hsatterwhite
2010-07-14 15:45:52