SQL Update and replace substring [duplicate]

Question

I want a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name

John Woo · Accepted Answer · 2013-05-02 09:41:27Z

52

use REPLACE()

UPDATE tableName
SET first_name = REPLACE(first_name, 'a', 'b')

but remember that REPLACE() is case sensitive.

answered May 2, 2013 at 9:41

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

feeela Over a year ago

dev.mysql.com/doc/refman/5.5/en/…

Francisco Corrales Morales Over a year ago

is there another function that is not case sensitive ?, or a parameter we can pass to REPLACE ?

user2045846 · Accepted Answer · 2013-05-02 10:50:48Z

7

You can try this:

UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla LIKE '%blabla%';
OR
UPDATE name SET first_name = REPLACE (first_name, 'a', 'b') WHERE blabla = 'blabla';

answered May 2, 2013 at 10:50

user2045846

Collectives™ on Stack Overflow

SQL Update and replace substring [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related