mysql replace text in a table

Database

How i replace text in a table , me using mysql

without any edit into records from website control panel i wish to run a query so all domains like without www will include www.

or

wish to replace a word from a table from expertweb to expertwebworld using one query .

Here is the solution

update table_name set field = replace(field, 'foo', 'bar') where instr(field, 'foo') > 0;

Here field is the column name. it will do this without wasting time to edit the records from admin.

Gallery

Comments

Submit Reviews:

Promotional Ads

Amazon Great Gifts Starting 45% Off Sale | Live Now >

Rebar Couplers India
10 A & B Industrial Area(at Vill. Nangal Jarialan) Distt. Una, Himachal Pradesh
Una

Rock Bolts
10 A & B Industrial Area(at Vill. Nangal Jarialan) Distt. Una, Himachal Pradesh
Hisar

Shree Ji Packers And Movers
478/1 Gali Number 2 , Adarsh Nagar, Sector 13, Chandigarh, 160101

JB Rock Bolts & SN BOLTS
10 A & B Industrial Area (at Vill. Nangal Jarialan)
Distt. Una Himachal Pradesh
Una

Packers and Movers in Zirakpur - Packers and Mover
SCO 3 AKS 2, Bhabat Rd, near Post Office, Zirakpur

Website Design and Development
Bangalore
Hyderabad

JF Engineering Products LLP
Parhar Village, Near Vasai Fata, Eastern Express Highway, Vasai (E), Palghar,
Motilal Nagar Mumbai

Nandishwar Steel
51 M.G. Mahimtura Marg, 3rd Kumbharwada Lane, Opp. Durgadevi Garden
August Kranti Marg Mumbai

Best Gastroenterologist in Ahmedabad
Ambika Chowk, Ramnagar Rd, Opposite Ramji Mandir, Sabarmati, Ahmedabad, Gujarat 380005
Ahmedabad

Lanco Pipes and Fittings
Shop No.1, Ground Floor, Plot No- 89 / 91, Shree Ram Mandir Marg, 4th Kumbharwada, Girgaon
August Kranti Marg Mumbai