[ad_1]
You can’t use not like directly in a show tables statement, but you could put it in a where clause:
SHOW TABLES WHERE tables_in_db NOT LIKE 'wp_2_%';
[ad_2]
solved NOT LIKE not working with SHOW [duplicate]
[ad_1]
You can’t use not like directly in a show tables statement, but you could put it in a where clause:
SHOW TABLES WHERE tables_in_db NOT LIKE 'wp_2_%';
[ad_2]
solved NOT LIKE not working with SHOW [duplicate]