[SOLVED] Updating column in a table using phpmyadmin

[jck]

i have about 60 records in a table and in each there is a column called itemtype which is empty i need to update all of them to T how can i do it easily

[trq]

UPDATE tbl SET itemtype = 'T' WHERE itemtype = '';

[rameshfaj]

update table_name set column_name='T' where column_name='';

[trq]

update table_name set column_name='T' where column_name='';

 

Well said!