Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Need some help with SQL command


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


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4546223.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com