SQL Query for wp_posts Wordpress

S

shizzledizzleeee

Regular Member

Jan 3, 2013

407

83

• Mar 14, 2023

• #1

I want a query that finds the first occurrence of "Word" in each post_content field, replaces it with a hyperlink.

This did not work



My posts are in draft.

 

Smackhead

Regular Member

Dec 22, 2021

391

222

• Mar 14, 2023

• #2

What did not work?

 

S

shizzledizzleeee

Regular Member

Jan 3, 2013

407

83

• Mar 14, 2023
• Thread Starter Thread Starter

• #3

Smackhead said:

What did not work?

Click to expand...

I am having issueS sharing SQL Query here

 

J

juggnfinesse

Newbie

Dec 10, 2019

23

5

• Mar 17, 2023

• #4

This should work.

 

S

shizzledizzleeee

Regular Member

Jan 3, 2013

407

83

• Mar 17, 2023
• Thread Starter Thread Starter

• #5

juggnfinesse said:

This should work.

View attachment 247121

Click to expand...

Ok I will try it out.