select * from (select TABLE_NAME from information_schema.tables) as bc where TABLE_NAME like '%r%' 这条sql语句对大家可能有用。。。