changing data in a specific field
March 11th, 2010 by , under nnmj.com.
except when i imported all the usernames into the database, htmlemail field was not set.. so all users are set to 0 in the field..
i have 24000 users on the list and i don't want to go thru each record individually to change this..
is there a mysql query or anything where i can change the data in a specific field in a table all at once.
ie.. the table is Table phplist_user_user (http://login.valuehost.co.uk/mysqladmin/tbl_properties.php?lang=en-iso-8859-1&convcharset=iso-8859-1&server=2&db=tomo55_mail&table=phplist_user_user)
the structure has 15 fields within that table.. 1 of them being HTMLEMAIL.
all data in this field for each record is 0 and i want to change every record so that the htmlemail field contains a 1 not 0 is there a way of doing this using phpmyadmin?
#If you have any other info about this subject , Please add it free.# |
