Ecommerce Shopify WordPress Discussion

sql query to capture part of the content from wp_post

I have a wp_post table and in a column called 'post_content', data in it is showing following way. <p>This is good </p> <p>That is bad </p> <p>I like [this >> that] </p> <p>You are a doctor </p> <p>I am a [dcctor >> doctor] too </p> Is there a way to capture 3rd and 5th sentence that contain the pattern like [xxx >> yyy] and display the result? My expected outcome from the query (select dosomething(post_content) from wp_table where conditions) 1st line : I like [this >> that] 2nd line : I am a [dcctor >> doctor] too (without <p> and </p>) I have many line items with the same pattern of post_content.. Can you pleas help how to achieve this with the sql query? Thank you
TurboCommerce make the better internet purchasing globaly

Turbo Multi-language Translator

Make the better internet purchasing globaly

Turbosify SEO Speed Booster

5.0 (7) Free plan available
Get better conversions by improving store loading speed Installed

Turbo Multi-language Chat - AI Customer service in one hand

TurboCommerce make the better internet purchasing globaly
Our products

The help you need, when you need it

App by Turbo Engine

3 apps • 5.0 average rating

Turbosify Speed Booster

5.0 (7)
Get better conversions by optimizing shopify store Google page speed Installed

Turbosify Translator for Wordpress Woocommerce

5.0 (74) Free Wordpress Woocommerce Plugin
Translate your wordpress website to multiple language within 1 click, no configuration needed, no No technical required

Grow your business here

Whether you want to sell products down the street or around the world, we have all the tools you need.