Is it possible to MASS UPDATE the contact_name field throughout the database.

As it is, all the data I have has no contact name but I'm setting the contact_name field to not null so I will need to add something in there to stop errors when updating.

Im looking for a mysql command that will do this.

Many thanks.
------------
ATEX 100

UPDATE lsql_Links SET Contact_Name = 'putseomthinghere' WHERE Contact_Name = ' ';


OR to change every link in the database to the same name:

UPDATE lsql_Links SET Contact_Name = 'putseomthinghere';


http://www.iuni.com/...tware/web/index.html
Links Plugins

Looks good. I'm keep promising to learn these commands as no doubt I'll need others in the future. Much appreciated.


------------
ATEX 100