Search and replace in MySQL – numeric values [on WordPress]

I have a live WordPress setup that has more than 5k comments.

Database Name: fhfh_wpdb535

Table Name: kevi_comments

Column Name under “kevi_comments” table: comment_content

Thousand of comments content have a lot of numeric value that look something like:

USECASE 1

93648847498442357831

936488/474/984423/578343

936488 / 474 / 984423 / 578343
4075936487

25/04/2016

648373

etc.

Now, how do I replace all these in numbers in bulk with asterisks (*). So, after this, the above mentioned entries in the database will look something like these:

93648847498442357831 —>>>> ********************

USECASE 2
Similarly, there are email IDs too.. like abc@gmail.com. How do I replace them too with something like ***@******** or **************

Read more here: Search and replace in MySQL – numeric values [on WordPress]

Leave a Reply

Your email address will not be published. Required fields are marked *