The information_schema table saves information about databases, tables, columns, indexes and triggers, etc.
To list all MyISAM tables, we can use following SQL
|
1 |
select * from information_schema.tables where engine='MyISAM'; |
And to find MyISAM tables in database wordpress
|
1 |
select * from information_schema.tables where engine='MyISAM' and table_schema='wordpress'; |
Next filter them with a table prefix wp_
|
1 |
select * from information_schema.tables where engine='MyISAM' and table_schema='wordpress' and table_name like 'wp_%'; |