Sorry, I didn't use replace yet, I always work with update which
is what I want. Are you sure you want to use replace? See the
differences in the manual. The syntax for update is
UPDATE table_name
SET col1 = '$val1',
col2 = '$val2',
col3 = '$val3'
WHERE p
I would be grateful if someone could tell me how to replace a single
value in a table.
What i want to do is something like
REPLACE contacts (access) VALUE ('P') WHERE id=x
but this doesn't seem to work. (and i can't use REPLACE SELECT becasue
this would require selecting on same table as repla