How i make a custom sql query for Woocommerce

I am not good at SQL but I believe this SQL query will do the job for you.

UPDATE wp_posts 
SET post_status="publish" 
WHERE post_type="product" AND post_status="trash";

Please remember to change WP database prefix if it is not default wp.

Related Posts:

  1. How to display SQL query that ran in query?
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom query filter not working on woocommerce category page
  6. how to retrieve specific product attribute value in an sql query?
  7. Show recent products first but “sold out last” in query
  8. WordPress creating excessive joins on meta_query with search
  9. cron job to auto delete posts of a specific post type older than x days
  10. Are database queries created using WordPress filters protected from SQL injection?
  11. Get posts by category with pure SQL query
  12. Custom query to get terms from post ids
  13. Get the timout value of a saved transient?
  14. What’s wrong with my $wpdb prepare?
  15. Get stock by custom meta field on all Woocommerce variable products
  16. Query Strings and Woocommerce
  17. How do I see the mysql query generated by get_posts( $args )?
  18. sql select query in wordpress ‘page’ [closed]
  19. problem with sql query in wordpress plugin
  20. Attempt to improve WP search, can someone check my SQL query?
  21. wpdb query problem to access previous 3 days posts
  22. I can’t figure out what’s wrong with this statement. $wpdb->query update
  23. Custom Query – Based on user input
  24. how to insert missing tags into the posts through mySQL?
  25. Query Nickname rather than Display Name in custom Woocommerce plugin
  26. $wpdb->prepare affecting the query?
  27. WordPress SQL search, how to handle SQL Injection?
  28. exclude pingbacks from wordpress SQL query
  29. prepare function sql safe method
  30. WordPress SQL query to tag all posts containing a specific word on title
  31. Select column name dynamically mySQL Query
  32. How do I query for posts by custom meta and those that have been stickied?
  33. Change pure SQL database query to WordPress post query?
  34. Cannot get sql request from Query object?
  35. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  36. Display data from phpMyAdmin with WordPress
  37. SQL to Query the db and return all posts and it’s metas
  38. SQL query to delete users with multiple meta keys and comments
  39. Nested select statements not working
  40. Speed up search query that searches in post meta?
  41. Category_in return empty
  42. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  43. Fastest and most efficient SQL query to check if UID exists
  44. How to make MySQL search queries with quotes
  45. $wpdb query for price in custom field value
  46. Run an update query in a function
  47. How to display a specific category using a custom Query in WordPress?
  48. Slow query when joining wp_posts with a lookup-table?
  49. Wpdb generates too many queries
  50. learn to run wpdb class
  51. SQL Query : how copy all tags of post into their post content in wordpress by sql query
  52. Where can I find the SQL to get the most used information by wordpress database?
  53. Custom Query for wp_posts using wp_postmeta
  54. WooCommerce Total # orders [closed]
  55. 3 queries to update WordPress
  56. What SQL Query to do a simple find and replace
  57. How to Optimize WP site for millions of posts
  58. Get Terms by IDs with IDs order
  59. Query WooCommerce orders where meta data does not exist
  60. How many WordPress SQL Queries per page?
  61. Slow wp_enqueue_media()
  62. How to display lastest post date in the homepage?
  63. Slow meta_query with about 4 milion record on wp_postmeta
  64. WordPress Find Duplicate Post By Content
  65. WP Query Sort by meta value (date)
  66. mySQL query. ORDER BY meta_key
  67. Disable the MySQL query in the main query
  68. Strange string in console from wpdb query
  69. How can I get the query that would be run for the archive page?
  70. Query metas (and not : query posts by metas)
  71. Select query for a login
  72. I can ‘t display product images based on the label
  73. wpdb print all post meta
  74. Export Specific User data without plugin
  75. How to write: $wpdb->update having WHERE NOT value pair in the array
  76. wpdb COALESCE won’t work
  77. Custom SQL Query passing array to WHERE p.id
  78. Query does not return content
  79. Query posts dynamic date range
  80. Parse query filter in wordpress and relation
  81. mySQL queries are executed twice on wordpress website
  82. List WordPress Post and Related Attachments outside of a post page
  83. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  84. Problem on displaying the results on my query
  85. SQL query – get a featured image’s alt / alternative text
  86. Improve performance of slow query
  87. WordPress search in modified post title
  88. Customising the default wordpress search functionality
  89. WC Booking query bookings with date ranges
  90. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  91. Set posts per page for parent category and it’s all children
  92. Exclude sticky posts from query
  93. If more than 1 image show post link?
  94. How to query different categories on index?
  95. How to specify what kind of is_single post?
  96. Print data from wordpress sql query
  97. Can I create my own query in wordpress with traditional methods?
  98. How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
  99. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  100. How to use a dynamic term id for the query block