Title: [Plugin: WordPress Reset] MySQL – escaping wildcards
Last modified: August 20, 2016

---

# [Plugin: WordPress Reset] MySQL – escaping wildcards

 *  Resolved [GRAQ](https://wordpress.org/support/users/graq/)
 * (@graq)
 * [14 years, 9 months ago](https://wordpress.org/support/topic/plugin-wordpress-reset-mysql-escaping-wildcards/)
 * Hi!
 * My question is regarding this code:
 *     ```
       global $wpdb;
                               $tables = $wpdb->get_col("SHOW TABLES LIKE '{$wpdb->prefix}%'");
                               foreach ($tables as $table) {
                                       $wpdb->query("DROP TABLE $table");
                               }
       ```
   
 * Based around the fact that ‘_’ is a single character mysql wildcard ([http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like](http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like))
 * I have multiple (non network) installations, each with a unique table prefix.
   Usually using the format `wp_mysite_ wp_anothersite_`. Do you know if the wpdb
   class is escaping that or can I get an upsetting hit on `wp_sandlewood_` with
   the prefix `wp_sandle_%`.
 * Does that make sense?
 * [http://wordpress.org/extend/plugins/wordpress-reset/](http://wordpress.org/extend/plugins/wordpress-reset/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Matt Martz](https://wordpress.org/support/users/sivel/)
 * (@sivel)
 * [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-wordpress-reset-mysql-escaping-wildcards/#post-2200312)
 * Fixed in 1.3.1

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: WordPress Reset] MySQL – escaping wildcards’ is closed to new
replies.

 * ![](https://ps.w.org/wordpress-reset/assets/icon.svg?rev=1330992)
 * [WP Database Reset](https://wordpress.org/plugins/wordpress-reset/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-reset/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-reset/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-reset/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-reset/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-reset/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Matt Martz](https://wordpress.org/support/users/sivel/)
 * Last activity: [14 years, 3 months ago](https://wordpress.org/support/topic/plugin-wordpress-reset-mysql-escaping-wildcards/#post-2200312)
 * Status: resolved