MySQL pattern matching and replace

Question

I have a table with settings column having the following data in three different rows:

{{product.description}}

{{user.email}}

{{last_date}}

I want to append the string '| format' with dynamic data, the output should be like this

{{product.description | format}}

{{user.email | format}}

{{last_date | format}}

I tried with MySQL REPLACE() method but problem is how to match this specified pattern.

What will be the UPDATE query for this?

Michael Woyo · Accepted Answer · 2015-02-06 06:25:01Z

0

you can use the REGEXP operator as follows:
SELECT (statement) REGEXP '{product.description}[.space.]|[.space.]format';

Hope it helps.

answered Feb 6, 2015 at 6:25

Michael Woyo

1482 silver badges15 bronze badges

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

2 Comments

What will be the UPDATE query to get the appropriate output

Please Check this link out. It has similar question and a solution. stackoverflow.com/questions/10465288/mysql-update-with-regexp