Problems with mysql syntax for replacing values

[authenticgeek]

I have a few rows with some data in them and I want to replace single values within these rows.

I\'m stuck on how to do it though.

 

Any suggestions?

[shivabharat]

Are u looking for something like this

 

SELECT REPLACE(\'phpfreak\', \'php\', \'mysql\') where cust_id=2;

[authenticgeek]

Ok. Here\'s what I tried again that doesn\'t work:

 

SELECT FROM student REPLACE(namel) WHERE idnum=4123 VALUES (Do);

[shivabharat]

:arrow: REPLACE takes 3 values as arguments

[authenticgeek]

Actually, the UPDATE command was what I was looking for.

 

UPDATE table_name SET column_name=updated_value WHERE value=yourvalue;

 

Thanks anyways