This is what I wanted to achieve, I hope it helps somebody
DELETE wp_posts FROM wp_posts
INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID
WHERE post_author = 1 AND post_date BETWEEN '2024-01-01 00:00:00' AND '2024-03-28 23:59:59';
Related Posts:
- DB prefix not updating
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- #1067 – Invalid default value for ‘post_date’ when trying to create a new column
- Inserting Post Meta From SQL
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- Delete all post meta except featured image
- How to execute mulitple statement SQL queries using $wpdb->query?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Query WordPress database by registered date and role
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Size article thumbnails and retrieve them directly from database
- Emojis getting converted to “?”
- Delete all post meta except featured image Using SQL
- wpdb_prepare with multiple or condition
- SQL Error wp_commentmeta – incorrect table definition
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- How do I get the posts within a certain year/date(with sql query)?
- WordPress database import: Row size too large
- WordPress Database Huge wp_usermeta Table
- Create table from array with prepare
- Changing root password in PHPMyAdmin for WordPress Database when going live
- Can’t update WordFence Options, clear data manually
- Why this query is not showing any result on wordpresss home page?
- How to migrate a database from a server to another
- Why does changing Database Table Prefixes result in loss of content?
- SQL query to set posts in bulk based on the post content
- Files on Localhost, Database on Server
- $wpdb->get_var – What value is returned when zero records are found?
- Installing local to live WP into subdirectory
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- How to create index (sql) to a meta_key?
- Delete all users meta that named: user_avatar
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- How to retrieve user data based on role using SQL?
- WordPress character set issue
- Missing latest posts and options after DB migration via phpMyAdmin
- Check if a database is well installed
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- export individual posts to text files or a single csv file
- SQL query : Select a thumbnail for a media
- why you don’t Implement PDO for access every thing to database
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- Database table prefix different between wp-config.php and in database
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- What is “Advanced” SQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Case statement in MySQL
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- How do I restore a dump file from mysqldump?
- MySQL SELECT increment counter
- Error Code: 2013. Lost connection to MySQL server during query
- how to drop partition without dropping data in MySQL?
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- difference between primary key and unique key
- Creating a search form in PHP to search a database?
- Oracle SQL query for Date format
- phpMyAdmin – Error > Incorrect format parameter?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- MySQL equivalent of DECODE function in Oracle
- How to create a foreign key in phpmyadmin
- importing a CSV into phpmyadmin
- MySQL: Can’t create table (errno: 150)
- How to do a batch insert in MySQL
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- Using wpdb to connect to a separate database
- MySQL Database User: Which Privileges are needed?
- Why is my database import losing text widget data?
- WPDB Insert or if exists Update
- Will it break my site if I delete all transient records in wp_options table?
- Checking if Database Table exists
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- Please explain how WordPress works with MySQL character set and collation at a low level
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How to fetch Data in WordPress using MySQLi or $wpdb
- WordPress Database lost auto increment
- Connect to database using wordpress wp-config file
- wpdb->insert multiple record at once
- Reset Post IDs to less than 64bit integer
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Restoring WordPress posts from database only
- WordPress database scalability from the code perspective
- How to define composite keys with dbDelta()
- Is it possible to define two databases for one installation?
- Does WordPress use the InnoDB engine for MySQL by default?
- Where are image paths to product category images stored in WordPress database
- Getting wrong relationship value in $args in wp_Query?
- Slow wp_term_relationships query
- How to use “TRUNCATE TABLE” MySQL statement?
- Sharing database for collaborative development
- Can I use MariaDB instead of MySQL in wordpress?
- Display data from a non wordpress database on a page template
- Organizing WP Pages based on old website database
- “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
- Using Dynamic Data Pulled from a MySQL Table in a WordPress Page