[SOLVED] Listing all tables with prefix

[eludlow]

I have taken over a database with several hundred tables, which I am slowly trying to organise into a more meaningful structure ie adding table name prefixes etc.

 

If I want to list all the databases that, for example, have the prefix "tr_" then this code:

 

SHOW TABLES FROM whateverdatabase LIKE '%tr_%';

 

works fine EXCEPT it also returns table names such as "rmm_entries" - I guess because it contains "tr" and an underscore.

 

How would I change the query to so as to exclude the "rmm_entries" and JUST list tables starting with "tr_"?

 

Many thanks in advance,

Ed Ludlow

[eludlow]

OK, as a follow up, I've found this works:

 

SHOW TABLES FROM pssru LIKE 'tr_%'

 

Can someone explain what the % actually means, as opposed to using an asterisk?

 

Thanks,

Ed

[richardw]

% is a wildcardas it "Matches any number of characters, even zero characters"