2013-07-23

How to search a wordpress database for shortcodes

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]+\]'
at

3 comments:

  1. Alia parkerNovember 14, 2021 at 5:19 AM

    This comment has been removed by the author.

    ReplyDelete
  2. Alia parkerNovember 14, 2021 at 6:14 AM

    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

    ReplyDelete
  3. denizAugust 15, 2023 at 7:12 AM

    kuşadası
    milas
    çeşme
    bağcılar
    tekirdağ

    BP7M

    ReplyDelete