Sql Update CPT from publish to draft and particular custom field

You’ll have to use JOIN to achieve this:

UPDATE wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id 
SET p.post_status="draft"
WHERE p.post_type="match" AND pm.meta_key = 'played' AND pm.meta_value = 0;

Related Posts:

  1. delete custom post based on custom field date
  2. 1 day after custom date change post status to draft
  3. How to import database table as custom post type and custom fields?
  4. Populate custom post type/custom fields from an external database
  5. Query custom fields with three dates – start and end does not work
  6. Query & Order posts by custom fields
  7. Filter custom posts using auto populated dropdown selectors
  8. How do I associate a custom post type with another through a taxonomy or storing an ID in a custom field?
  9. Custom post type content using custom fields without template
  10. Cannot add custom field to “orderby” parameter in Rest API
  11. What is the recommended / best way to do this: Event calendar post/type in a block-based theme?
  12. retrieve Meta field value from CPT and set those values as Image Meta Field “Title”
  13. Having unique constraints for custom fields in a custom post type
  14. Querying Two Custom Post Types with OR Not Working
  15. How can I get the number of custom post type posts that have a specific attachment image set?
  16. Trash / Draft a WordPress custom post after custom date field expires
  17. Set a maxlength for the title input in a custom post type
  18. Posting to a Custom Post Type from front end – user generated content
  19. Display custom fields from custom posts in RSS feed
  20. Bulk Update Custom Fields for Custom Post Types
  21. How can I use get_post_meta with add_rewrite_rule to build custom permalinks?
  22. Visual editor issue by having multiple tiny mce editors in a CPT
  23. WordPress Custom Fields Won’t Save
  24. Update Post Meta for a logged in user
  25. Problem querying Custom post type by custom fields
  26. Found 2 elements with non-unique id (#_ajax_nonce) and (#_wpnonce)
  27. Add custom field to Posts and sort by it
  28. Orderby CPT custom fields not working
  29. WP_Query order by custom field, then randomly order some of results
  30. A better way to add a meta box to custom post types
  31. Rows with custom columns not well formatted after Quick Edit save
  32. Featured image overlay when changing post status
  33. Plugin – Combine Meta Box Input Fields into single saveble record
  34. Two Custom Post Types Many to Many Relationship
  35. Show custom post type relationships by taxonomy
  36. get_post_meta not working on publishing
  37. Query custom post type with ACF Date
  38. Custom setting to show or hide field
  39. Custom post type suppress transition from future to publish
  40. Custom Meta Field – Remove comma from string with str_replace
  41. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  42. Using custom field content as expression in IF statement [closed]
  43. Meta Query Not Returning Output Despite Having Matching Values
  44. How to create a custom post type with additional fields?
  45. Callback to custom field is not working in WordPress REST API
  46. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  47. Including metaboxes from custom post types in global search — continued
  48. ACF From & To Date Validations
  49. How do I set all of a particular post meta to a value within the custom post type I’m in?
  50. Query Multiple Custom Posts by Custom Fields
  51. Show image gallery from a custom field
  52. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  53. Dynamic dropdown select values depending on other custom field value
  54. How to render a custom post type template with custom fields using shortcode
  55. Disable saving posts as draft (make all posts mandatory regardless of the post status)
  56. Grouping metadatas into one
  57. Tracking changes in admin-page so user gets warning when leaving the page
  58. filter custom post in rest api with custom function
  59. Get Posts by multiple custom fields is not working
  60. Woocommerce custom field search in custom post type [closed]
  61. Update postmeta Parent when post_status child change
  62. Add custom field in comments form
  63. Custom Fields for Custom Post [closed]
  64. Order Custom Post Type by Custom Field Value
  65. Filter custom post types by a field value
  66. Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
  67. Assign External Database Queries to Global Variables and Make Them Accessible
  68. Repeatable Fields Metabox with Textarea (or wp_editor)
  69. How to use TinyMCE Editor for one of my custom post meta field?
  70. Custom REST endpoints for a custom post type with custom fields
  71. How to import a custom MySQL DB table into a WordPress custom post type
  72. How to Create a WordPress Plugin With Custom Post Type/Custom Field Features?
  73. Hierarchy and access control for Custom Post Types (CPT)
  74. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  75. How to integrate a form (Ninja Form or Contact Form 7) with Custom Post Types?
  76. Function causing the loop display posting more (empty)
  77. First custom field value (out of several) displayed twice after query
  78. Homepage’s content is dependent on the custom field values (set automatically), how do I get homepage to update without manually updating page?
  79. Meta Query posts not showing on ending date of custom field
  80. Cannot save CPT meta box
  81. Cross reference custom post types
  82. Removing all post statuses from a Custom Post Type
  83. Adding Page Templates to post but it ignored it
  84. Include related custom fields from one post type in another post type’s JSON feed
  85. Add custom post type drafts to RSS feed
  86. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  87. How to define which register_post_status goes to which register_post_type?
  88. frontend image post uploader
  89. Is there any way to add a “custom field” to the CPT archive page?
  90. How to Output which matched meta_keys were found from custom_type_posts?
  91. Multiple Frontend Filters Using Advanced Custom Fields
  92. Custom Post Fields at the beginning of a Custom Permalink
  93. Integrate Custom Post Type Events into Calendar
  94. Possible to filter custom post type with multiple meta data?
  95. Hierarchical custom fields
  96. How to get a custom field value of a custom post?
  97. Fields for different parts of a page
  98. wp_insert_post sometimes fails after API call
  99. Is it possible to activate customfield ‘text description’ upon activating the customfield ‘checkbox’?
  100. Facebook social publisher and custom post type fields [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)