MySQL 4 query assistance

[hspc]

Ok
the situation looks clearer
you want to updated the (values) of the column provider in the _products table from 'master' to 'suzan'


at first : take a backup of the table (easy using phpmyadmin)
then run this query:

update _products Set provider =  'suzan' where provider = 'master'

now all records with provider = master will change to suzan.
tell me if it works fine or if you find any problems, don't forget to take a backup before running queries that change a lot of records.