MySQL Replace function

Question

I am trying to display all the people who name Jason, and replace Jason to Jill.

However, I tried the following SQL statement is not working

SELECT * FROM DigitalTV WHERE REPLACE('Jason', 'ason', 'ill');

vahdet · Accepted Answer · 2019-02-14 18:03:02Z

1

Assuming that the column you want to replace names is called NAME, you can use a query like:

SELECT 
  *,
  REPLACE(NAME, 'ason', 'ill') As CHANGED_NAME
FROM DigitalTV 
WHERE NAME='Jason';`

This will bring an extra column with the name CHANGED_NAME. If you do not want it, use each and every column name in the selector but NAME. It should be modified as REPLACE(NAME, 'ason', 'ill')

answered Feb 14, 2019 at 18:03

vahdet

6,78910 gold badges62 silver badges116 bronze badges

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

2 Comments

unutbu Over a year ago

Since we know NAME='Jason', you could SELECT 'Jill' AS CHANGED_NAME. (No REPLACE necessary).

Johnson John Over a year ago

I currently have two columns, first_name, last_name. I want to make sure I can replace 'Jason' to 'Jill' in both columns

Collectives™ on Stack Overflow

MySQL Replace function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related