replace string in mysql

Question

I would like to replace "|" with "_" in mysql if meets the following query

SELECT COUNT(*) FROM wp_posts WHERE post_content REGEXP 'text\\(584\\|([a-zA-Z0-9_]+)\\|([a-zA-Z0-9_])'

so if finds for example text(584|g345|2344 should look at the end text(584_g345_2344

Is it possible if I use REGEXP to find matches?

Community · Accepted Answer · 2017-05-23 11:58:19Z

3

You can use:

REPLACE(text_string, from_string, to_string)

More info can be found in here.

EDIT:
However, you cannot mix REGEX and REPLACE.
You'll need to have it done with several queries, have you seen this?

CommunityBot

11 silver badge

answered Nov 12, 2012 at 10:24

Ofir Farchy

8,1257 gold badges42 silver badges58 bronze badges

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

1 Answer 1