This week I was tasked with performing a quick audit on an existing client site for WordPress 5.0 compatibility. The site had already made use of Gutenberg so we were curious just how many blocks were in use.
For those of you who don’t know, Gutenberg blocks are stored in the
post_content field and look something like this:
Now, since every block begins with the same pattern,
<!-- wp:, we now have something we can target in a SQL query. The trick is to count the number of times that pattern occurs in each
After a lot of research and consulting my amazing colleagues over at WebDevStudios I finally landed on a query that will get a count of every Gutenberg block published on your site. Here it is:
Just copypasta that query into your favorite MySQL client (or the cli if you’re hardcore) and you should see the magic number.