Simple mysql query help please

[emmah]

Hi everyone,

I know this will be simple but I just cant get it to work and I am being tested here by my line manager.

Our database is named: lsql_Category and we have a table column named: Keywords

We have thousands of rows

The column Keywords has data in most of the rows and some without any data at all. Normally assorted and various text words.

I want to clear all data from this coloumn but DO NOT want to delete the coloumn cos we want to input data at later time.

The result should be that the column Keywords remains but will not have any data.

Can someone help? I think it is a select command and a where command but that is all I know.

EmmaH

[khalidbaloch]

how about mysql query update

since you forgot to mention your database table i had to use table_name in place of of database table name . if this query is usefull please change table_name to what your table name is

mysql_query ("UPDATE table_name SET keywords='null');

also try ....

mysql_query ("UPDATE table_name SET keywords=''");