Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > MySQL > How do you REPLACE in MySQL?

How do you REPLACE in MySQL?

In: MySQL [Edit categories]

Answer:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

First answer by Mbud. Last edit by Mbud. Contributor trust: 368 [recommend contributor ]. Question popularity: 2 [recommend question].

[report abuse]

Can you answer these MySQL questions?

	What makes a database spatial?	Answer it!
	What is the difference between self join and Inner Join?	Answer it!
	What will be the entities of an airline database?	Answer it!
	What are the differences between Oracle and MySQL?	Answer it!
	What are the functions performed by the DBMS and DBA?	Answer it!

What is MySQL?
The world's most popular open source database[1] MySQL is a relational database management system, or RDBMS. Basically it's a software package that is very good at the organization and management...
How do you migrate MySQL 4.0 to MySQL 5.0?
IIRC mysql5 supports import of mysql4 data and structures natively (you can use mysql4 compatability when exporting sql data from phpmyadmin)
Do you HAVE to replace the flywheel if you replace the clutch?
If not replaced having it resurfaced is recommended.
How do you replace has?
Posseses. Owns.
When you replace a water pump do you have to replace the thermostat?
You don't have to but it would be wise to do so especially if the system over heated because of lost coolant.