MySQL can regex sweetness!
here is how to search wordpress posts for shortcodes
today we are searching for the shortcode
[auction startbid:250] or [auction startbid:100] etc so we can use regex to find all the shortcodes with various amounts.
select * from wp_posts where post_content REGEXP '\[auction startbid:[0-9]+\]'
![Stumble Upon CodePyro](http://www.codepyro.com/assets/icons/stumbleupon-logo-square-webtreatsetc.png)
![This.RSS.Subscribe()](http://www.codepyro.com/assets/icons/rss-basic-webtreatsetc.png)
![Checkout My LinkedIn](http://www.codepyro.com/assets/icons/linkedin-logo-webtreatsetc.png)
![Checkout My Twitter](http://www.codepyro.com/assets/icons/twitter-webtreatsetc.png)
3 comments:
This is my first visit to your internet journal! We are a team of volunteers as well as new tasks in the same specialized. Site provided us helpful data to work. Typeform alternative
kuşadası
milas
çeşme
bağcılar
tekirdağ
BP7M
Post a Comment