Title: Gideon7's Replies | WordPress.org

---

# Gideon7

  [  ](https://wordpress.org/support/users/gideon7/)

 *   [Profile](https://wordpress.org/support/users/gideon7/)
 *   [Topics Started](https://wordpress.org/support/users/gideon7/topics/)
 *   [Replies Created](https://wordpress.org/support/users/gideon7/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/gideon7/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/gideon7/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/gideon7/engagements/)
 *   [Favorites](https://wordpress.org/support/users/gideon7/favorites/)

 Search replies:

## Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Optimize Database after Deleting Revisions] Fails on MySQL 8.0.18+ (INFORMATION_SCHEMA)](https://wordpress.org/support/topic/fails-on-mysql-8-0-18-information_schema/)
 *  Thread Starter [Gideon7](https://wordpress.org/support/users/gideon7/)
 * (@gideon7)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/fails-on-mysql-8-0-18-information_schema/#post-14108800)
 * Wonderful, and thank you so much for the fast response.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Db Abstraction] [Plugin: WP Db Abstraction] Database Update Issues](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/)
 *  [Gideon7](https://wordpress.org/support/users/gideon7/)
 * (@gideon7)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812788)
 * To handle NULL cases use ISNULL(meta_value,”), like this:
 * `SELECT COUNT(CASE WHEN ISNULL(meta_value, '') LIKE '%"administrator"%' THEN 
   1 ELSE 0 END) as Computed, ...`
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WP Db Abstraction] [Plugin: WP Db Abstraction] Database Update Issues](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/)
 *  [Gideon7](https://wordpress.org/support/users/gideon7/)
 * (@gideon7)
 * [13 years, 11 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-update-issues/#post-2812787)
 * I get the same error on a fresh install of WordPress 3.4.1 on IIS 7.5 with SQL
   Server 2008 R2. Whenever I try to add a new user I get:
 *     ```
       WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'LIKE'.]
       SELECT COUNT(NULLIF(meta_value LIKE '%"administrator"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"editor"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"author"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"contributor"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"subscriber"%', false) as Computed), COUNT(*) as Computed FROM wp_usermeta WHERE meta_key LIKE 'wp_capabilities'
       ```
   
 * The problem is that naked boolean expressions are not allowed inside of a function.
   The above needs to be re-written to use a numerical expression:
 * `SELECT COUNT(CASE WHEN meta_value LIKE '%"administrator"%' THEN 1 ELSE 0 END)
   as Computed, COUNT(CASE WHEN meta_value LIKE '%"editor"%' THEN 1 ELSE 0) as Computed...`

Viewing 3 replies - 1 through 3 (of 3 total)