Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Delet from a specific field?

Quote Reply
Delet from a specific field?
Hi,

Does anyone know the SQL command to delete the contents of a field across all records, e.g.; empty all keywords from the keywords field?

Thanks.
Shaun



Quote Reply
Re: Delet from a specific field? In reply to
UPDATE Links SET Keywords = null;

Regards,

Eliot Lee
Quote Reply
Re: Delet from a specific field? In reply to
Thanks Eliot

All the best
Shaun

Quote Reply
Re: Delet from a specific field? In reply to
You're welcome....

http://www.mysql.com

is a good starting point for basic SQL functions/statments that you can use in MySQL.

Regards,

Eliot Lee