Jump to content

Archived

This topic is now archived and is closed to further replies.

authenticgeek

Problems with mysql syntax for replacing values

Recommended Posts

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?

Share this post


Link to post
Share on other sites

Are u looking for something like this

 

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

Share this post


Link to post
Share on other sites

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

 

UPDATE table_name SET column_name=updated_value WHERE value=yourvalue;

 

Thanks anyways

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.