CODEWITHSUNDEEP
mysqlsqlsql-update
kitokid
kitokid

Reputation: 3117

update column data mysql

I have the table name course which has coursename column.

As you can see "seaadventures" and "sea adventures" etc.. info names are different, and want to make it to "sea adventures" for all matched words "seaadventures", How can I check and update it across DB ?

coursename:

seaadventures watersport1
sea adventures watersport2
cool seaadventures sport

Upvotes: 1

Views: 1196

Answers (3)

Vipin Kumar
Vipin Kumar

Reputation: 17

You can use 

Update course Set coursename='sea adventures' where coursename like '%seaadventures%'

Upvotes: 1

Iswanto San
Iswanto San

Reputation: 18569

Just REPLACE every seaadventures to sea adventures

UPDATE course 
SET coursename = REPLACE(coursename, 'seaadventures', 'sea adventures')

Upvotes: 1

John Woo
John Woo

Reputation: 263723

use REPLACE() function,

UPDATE  tableName
SET     courseName  = REPLACE(courseName, 'seaadventures', 'sea adventures')

Upvotes: 4

Related Questions