show tables like in mysql

SHOW TABLES WHERE Tables_in_mydbname LIKE '%reward%'

suppose mydbname is 'blogposts'

SHOW TABLES WHERE Tables_in_blogposts LIKE '%reward%'