Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Automated SQL query to place/replace a value

Quote Reply
Automated SQL query to place/replace a value
Hi,

I have recently added a new column to the links table and in order for it to work I need to fill this column of every link with a value, except if the column has already a certain value, let's say 1. Is that possible and if so how?

Stuart
Quote Reply
Re: [vacationrentals] Automated SQL query to place/replace a value In reply to
UPDATE MYTABLE SET MYFIELD = 'value' WHERE (MYFIELD=NULL OR MYFIELD='')

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...