Sigmascripts
  • Marketing
    • Digital marketing
    • Seo
    • website
  • Javascript
    • Jquery
  • PHP
  • WordPress
    • wordpress plugin
    • wordpress themes
  • Tips and trick
  • Tools
    • WordPress Custom Post type generator
    • SEO tools
No Result
View All Result
Sigma Scripts
  • Marketing
    • Digital marketing
    • Seo
    • website
  • Javascript
    • Jquery
  • PHP
  • WordPress
    • wordpress plugin
    • wordpress themes
  • Tips and trick
  • Tools
    • WordPress Custom Post type generator
    • SEO tools
No Result
View All Result
Sigma Scripts
No Result
View All Result

how to delete posts by post meta in WordPress

Abhishek Bhardwaj by Abhishek Bhardwaj
March 17, 2022
in Wordpress
0 0
0
how to delete posts by post meta
0
SHARES
208
VIEWS
Share on FacebookShare on Twitter
Table Of Contents
  1. Here is the sql query to delete posts by post meta
  2. Conclusion
  3. Check out other articles on WordPress too.

Many times, you often want to delete posts by post meta in WordPress and you couldn’t find any plugin for that, In that case, you need to run SQL query from your PHPMYADMIN. Today we will discuss how to delete posts by post meta in WordPress.

I’ve created a custom SQL code from that you can easily delete the posts by post meta.

Here is the sql query to delete posts by post meta

DELETE p, pm
  FROM wp_posts p
 INNER
  JOIN wp_postmeta pm
    ON pm.post_id = p.ID
 WHERE pm.meta_key = 'your_meta_key'
   AND pm.meta_value = 'your_meta_value';

Here wp_posts is post table and then I’ve added the join in post meta table(wp_postmeta). in where condition I’ve added the meta_key that is the post-meta key and value. Please note that you can add your key and value.

ADVERTISEMENT
ADVERTISEMENT

Conclusion

All you just need to copy the code with a single click and then paste in your PHPMyAdmin and change the values. you don’t need any plugin for it.
If you like the article and this article solve your problem, then share it with your friends, it’s free 🙂

Check out other articles on WordPress too.

  • What is a Backlink in SEO? How to get Free Backlinks?

    August 18, 2022

    ADVERTISEMENT ADVERTISEMENT A backlink is one of the most used words in the world of SEO. In this post, I hope to offer you an understanding of what is backlink in SEO and free ideas to get backlink for your website or blog. Many bloggers who have only recently started a blog or a website […]

  • How to Duplicate a Page in WordPress?

    August 18, 2022

    WordPress duplicate a page: WordPress allows users to duplicate a page and post in more ways that just by copying and pasting the content. In this article, we will talk about the reliable ways that will help you to duplicate pages or posts of your WordPress site. You can done this job with and without […]

  • What should be the first tag in any HTML document?

    August 15, 2022

    There should be <html> in the first tag in any html document. It will let the web browser know that it is an HTML file. Otherwise, there is no chance that the browser will know that it is an HTML file. And all the other options are tags that have to be used later after […]

1 2 3 … 20
Next Page
  • What is a Backlink in SEO? How to get Free Backlinks?

    August 18, 2022

    ADVERTISEMENT ADVERTISEMENT A backlink is one of the most used words in the world of SEO. In this post, I hope to offer you an understanding of what is backlink in SEO and free ideas to get backlink for your website or blog. Many bloggers who have only recently started a blog or a website […]

  • How to Duplicate a Page in WordPress?

    August 18, 2022

    WordPress duplicate a page: WordPress allows users to duplicate a page and post in more ways that just by copying and pasting the content. In this article, we will talk about the reliable ways that will help you to duplicate pages or posts of your WordPress site. You can done this job with and without […]

  • What should be the first tag in any HTML document?

    August 15, 2022

    There should be <html> in the first tag in any html document. It will let the web browser know that it is an HTML file. Otherwise, there is no chance that the browser will know that it is an HTML file. And all the other options are tags that have to be used later after […]

1 2 3 … 20
Next Page
wordpress duplicate a page

How to Duplicate a Page in WordPress?

Abhishek Bhardwaj August 18, 2022 No Comments
WordPress duplicate a page: WordPress allows users to duplicate a page and post in more ways that just by copying and pasting the content. In …
Read More
Best Niche For Blogging

Best Niche For Blogging – Website Ideas to Make Money

Abhishek Bhardwaj August 1, 2022 No Comments
If you are searching best niche for blogging then your searching is over after reaching this article. In this article, we’ll explore website ideas to …
Read More
SEO Plugin for WordPress

Best SEO Plugin for WordPress for Boosting Website Traffic Free

Abhishek Bhardwaj July 31, 2022 No Comments
Here are some of best SEO plugin for WordPress, SEO plugins can be incredibly useful if you’re not sure how to encourage search engines to …
Read More
Free Online Courses Platform with Certificate

Free Online Courses Platform with Certificate

Abhishek Bhardwaj July 30, 2022 No Comments
There are lots of free online courses platform with certificate. The Online Learning College have a wide range of courses all with quality tutor support …
Read More
VCard

Benefits of Digital Business Cards.

Abhishek Bhardwaj July 14, 2022 2 Comments
Nowadays, business cards are used not only to share contact information but also to build business brand. Virtual or Digital Business Cards are electronic formats …
Read More
best free wordpress themes for blogs

Best free WordPress themes for blogs

Abhishek Bhardwaj July 13, 2022 2 Comments
Are you looking for the Best free WordPress themes for blogs? Then you are in the right place. We will introduce you free WordPress themes …
Read More
Previous Post

How to increase memory limit in wordpress

Next Post

5 SEO tips to Improve Organic Search Ranking easily.

Abhishek Bhardwaj

Abhishek Bhardwaj

Next Post
5 SEO tips to Improve Organic Search Rankings

5 SEO tips to Improve Organic Search Ranking easily.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

You might also like

what is a backlink in seo

What is a Backlink in SEO? How to get Free Backlinks?

August 18, 2022
wordpress duplicate a page

How to Duplicate a Page in WordPress?

August 18, 2022
What should be the first tag in any html document?

What should be the first tag in any HTML document?

August 16, 2022
Google Web stories

What are Google Web Stories? Is it Worth it?

August 15, 2022
What is mongodb?

What is Mongodb atlas? Is this Free to learn?

August 15, 2022
What is python programming language

What is python programming language

August 15, 2022

Grow your online business presence with the best digital marketing strategy offered by Sigmascripts. You will get all about WordPress, digital marketing, SEO, etc. We deliver the best ideas to grow you through the Online platform.

Stay Connected

  • About us
  • Privacy Policy

© 2022 sigmascripts.com

No Result
View All Result
  • Marketing
    • Digital marketing
    • Seo
    • website
  • Javascript
    • Jquery
  • PHP
  • WordPress
    • wordpress plugin
    • wordpress themes
  • Tips and trick
  • Tools
    • WordPress Custom Post type generator
    • SEO tools

© 2022 sigmascripts.com

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In