How to apply media query in table?

WordPress Plugin Development: How can I set a MySQL query to specify the options table using a user defined prefix?

• I have the following line in my plugin to remove transients from the database option table. $wpdb->query( "DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient%_feed_%')" ); However, it won't work with sites which set a prefix to the database name in wp-config.php. For example, if the prefix is set to wp_something as follows, $table_prefix = 'wp_something'; The option table name becomes wp_somethingoptions. Then the above MySQL query does not work because it uses the table name wp_options. So how can I make it so that it accepts a prefixed table name set by the user?

• Answer:

  Use the global wordpress variable $table_prefix in your query: $wpdb->query( "DELETE FROM `" . $table_prefix . "options` WHERE `option_name` LIKE ('_transient%_feed_%')" );