Title: WooCommerce SQL errors
Last modified: August 24, 2016

---

# WooCommerce SQL errors

 *  [chrissilich](https://wordpress.org/support/users/chrissilich/)
 * (@chrissilich)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/woocommerce-sql-errors/)
 * When searching for WooCommerce SKUs in the admin interface I get an error:
 * WordPress database error: [You have an error in your SQL syntax; check the manual
   that corresponds to your MySQL server version for the right syntax to use near‘)
   AND post_status != ‘future’ ORDER BY wp_posts.post_title LIKE ‘%16199%’ DESC,’
   at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE
   1=1 AND ( ( (((((wp_posts.post_title LIKE ‘%16199%’) OR (wp_posts.post_content
   LIKE ‘%16199%’)))))) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status
   = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’
   OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’)) AND
   post_type != ‘revision’) AND post_status != ‘future’ ORDER BY wp_posts.post_title
   LIKE ‘%16199%’ DESC, wp_posts.post_date DESC LIMIT 0, 20
 * [https://wordpress.org/plugins/search-everything/](https://wordpress.org/plugins/search-everything/)

The topic ‘WooCommerce SQL errors’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/search-everything_242529.svg)
 * [Search Everything](https://wordpress.org/plugins/search-everything/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/search-everything/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/search-everything/)
 * [Active Topics](https://wordpress.org/support/plugin/search-everything/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/search-everything/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/search-everything/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [chrissilich](https://wordpress.org/support/users/chrissilich/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/woocommerce-sql-errors/)
 * Status: not resolved