jadebox - 9:48 pm on Feb 18, 2013 (gmt 0)

UPDATE posts SET source='http://domain-name.com' WHERE source = ''

But ... the right solution is probably to set the default value of the source column to "http://domain-name.com". You only have to do it once:

ALTER TABLE posts ALTER source SET DEFAULT 'http://domain-name.com'

-- Roger