Like keepkalm said I’d find the list of post IDs from the database:
select id, post_title FROM wp_posts
where post_title like '%Pharmaton%'
or post_title like '%Winston Blu%'
or post_title like '%Kefir%'
or post_title like '%Tetradox%'
or post_title like '%Passport Sco%';
and then use the list of IDs with wp-cli’s wp post delete
which accepts a space-separated list of post IDs:
wp post delete 1 2 3 4
(You could also use wp post list to get all titles and IDs in the system, and grep to filter the list down to the posts you want, awk or similar to extract the list of IDs and then pass that all to wp post delete in one go – but this feels safer to do as a semi-manual process since you’re deleting things.)
Related Posts:
- When tax_query used, results disappear (0 =1 produced)
- WP_Query in functions.php
- mysql custom wp query
- How to get last updated row or ID in wordpress
- Removing the first image in content
- Gravity Forms field entries into wp_query loop [closed]
- Is it good practice to use wpdb->query() function?
- list tags with count in author profile page
- wp_is_mobile dequeue not working
- Having a Function Inside of the Loop
- Wp_query function to search from product_title ‘OR’ product tags name
- Dynamic dropdown from database table
- Display tags that only appear in one category
- Custom Query Not Paginating
- Reset postdata not working on WP_Query in functions.php
- Wp-query Order By problem
- How is $current_page passed in woocommerce_account_orders function?
- wp_usermeta – Read from database, but save function broken
- How to apply the ‘current_page_item’ class to an archive page in `wp_list_pages()`?
- Filter for replacing the WP_query object for a given category
- How to avoid saving empty data to sql while using add_meta_box
- Create a CUstom Archive by Year, but just for a Single Category
- Updating custom query var with multiple values
- WP_Query for Attachments not working as expected
- query_vars treat as single var from URL
- Writing a function for WP Cron to run a SQL command daily
- Delete oldest wordpress post (SQL query)
- How can I display a query in a page?
- Function returning queried meta value based on current post ID
- Optimizing multiple WP_querys into one call?
- Query is not work
- Integrating custom API for post content into Admin interface & Public Website [closed]
- Automatically delete posts that aren’t in an array
- Insert image between X number of posts but on specific paginated pages?
- get last part of page url and add it as cat in wp_query
- Passing User_Fields to Contact form 7 [duplicate]
- new_excerpt_more link not working properly
- PHP mixed with some JS code to update WordPress theme settings
- wp_get_archives custom function broken since upgrading to WP 3.7.1
- Where to add the permalink in this function?
- Custom taxonomy widget in admin area
- Get list of all custom tanonomy id
- Display gallery on bottom after content
- Add button to kitchen sink toggle
- Get User Login Data (date, time… )
- Show image exactly defined to a width
- media resize/crop possibilities?
- Using wp_redirect and .htaccess to re-route searches (and pass along the remaining GET vars)
- Multisite 404 on pages – rewrite error breaks database
- WordPress functions.php – Execute plugin specific user online
- watermarking gallery items
- wp-admin won’t load after setting wp-login custom url
- Post meta not updating
- Skeleton Child Theme Add Icon Bar to Header Flex Grid
- paginate_links() don’t properly work in search.php?
- Dashboard widget custom positioning?
- Difficulty with PHP function that displays a post’s format in WordPress
- Incorrect redirect after commenting
- Function to update post_meta based on existing post_meta
- Run wp_kses_decode_entities on atom feed?
- Query most popular terms by taxonomy over 2 week period
- List authors with the last post title and order by last post date
- Load jquery only for certain pages in the backend
- Events: Check for other event with same start date and category [closed]
- Update user meta of author when post content is viewed
- Filtering out the #more anchor link that gets produced by
- comments_popup_link without echo?
- Remove adjacent_posts_rel_link under 3.2?
- Registration Hooks don’t appear to be working
- Can’t filter wp_get_attachment_link
- How to load parent theme template parts in child theme
- How to create an onclick event on an image in a post?
- Impossible to call wordpress function inside an include?
- How do you Permanently Delete Sidebars
- Which functions/classes are available during SHORTINIT?
- WordPress Page Restrict
- Remove category from url
- Function added using `add_action()` not being called
- Excerpts are not displayed by a shortcode on category pages
- ‘Attempt to modify property of non-object’ warning
- Add a unique class to HTML tag/element
- Conditional functions.php on page template
- Do we have to use ftp to recover from a bad functions.php edit?
- Getting comment count per post not working
- Functions.php Problem
- How can this crude function be improved?
- WordPress function saves a post twice and updates all posts
- What does this code do? (Injected code hacked)
- Change CSS for logged in users
- current_time(‘timestamp’) seems to be different from the real current time
- Wp admin – Set default value to 999 in comments
- Removing specific menu items?
- Has is_archived() for sites in a multisite changed with WP 4.7?
- Always the Latest google jQuery instead of default WordPress jQuery
- Custom function causes a 503 error after a couple of hours
- WordPress listen to $_POST in functions.php
- Accessing two databases wordpress
- Add a jQuery Function
- What is the Difference in bones_comments() and comments.php
- How can I show my latest tweet in my wordpress blog?