List out all MySQL Tables by their prefix names

Filtering on numerous list of MySQL tables is often fun, not just tedious. I am explaining here how to get a list of tables within a database by their prefix names. This method can be further useful when you want to operate an action on list of those tables; like changing their storage engine or, even dropping those tables.

The DATABASE() gives the name of current database you have switched to, or an empty string. Then analyze the SQL below on Information Schema, a system level database accessible to all users.

Within this modern buying generic viagra world Kamagra online is providing the most amazing medical tourism facilities in India. Young adults and kids have an amazing reserve of resiliency and can bounce back buy sildenafil online if healthy directives are taken. However, it is also noticed that generic tadalafil cheap the underlying condition can be affected by other factors. Getting a pill to improve erection quality has been trusted for over a decade. levitra online sales

There is a difference, compared to SHOW TABLES because, here, we can implement WHERE and even use CONCAT on table names.

But, please do not wipe out your list of WordPress tables with wp_ prefix!