How to enable reviews on all WooCommerce Wordpress products?

Question

SQL

I found on the Internet that you can make a SQL query in phpmyadmin

UPDATE `wp_posts` SET comment_status = 'open'
WHERE `post_type` = 'product'

But I get an error


. I tried to write USE 'database name' at the beginning and got a new error.

USE 'database name'
UPDATE `wp_posts` SET comment_status = 'open'
WHERE `post_type` = 'product'
MySQL Response: Documentation

#1064 - You have a query error. Check the documentation for your version of MySQL for the correct syntax around ''database name''
UPDATE `wp_posts` SET comment_status = 'open'
WHERE `post_t' on line 1

Answer 1

semicolon missing between USE and UPDATE