How to Replace a Text String in a MySQL Table Field Value

In this simple tutorial you will learn to replace a text string in a MySQL table field value.

I have a races table in which I store race event information. In the date field I store event date. Since these events are recurring the information stored is applicable to upcoming years as well.

So I have a date field in my mysql database table named races. I want to replace year 2022 in this field to 2023

The following command will do this.

UPDATE races SET `date` =REPLACE( `date` , '2022', '2023' ) WHERE INSTR( `date` , '2022' ) > 0

I hope this simple example to replace string value in a MySQL table field helps you.

Leave a Reply