MYSQL查询查找和替换两个短语

Ive got this dynamic phrase on ALOT of posts with a different job title.

我已经在ALOT上有一个不同职位的帖子上有这个动态短语。

"stats gathered across the U.S. 95% of Flight Department Managers were males while 95% were females"

“美国95%的飞行部门经理都是男性,而95%是女性”

I need to to do a mysql query that will find and replace all posts on my wordpress that have both of these two sub phrases below.

我需要做一个mysql查询,它将查找并替换我的wordpress上的所有帖子,这些帖子同时包含以下两个子短语。

"stats gathered across the U.S. 95% of"

“统计数据聚集在美国95%的”

"while 95% were females"

“而95%是女性”

Not sure how to do this, any help would be appreciated.

不知道如何做到这一点,任何帮助将不胜感激。

1 个解决方案

Here's a good resource which should have what you need.

这是一个很好的资源,应该有你需要的东西。

Here's a good resource which should have what you need.

这是一个很好的资源,应该有你需要的东西。