Search the table from database using sql

How can search the table name from the existing database if there are table exist but I forgot the full name of table in sql

Solution:- select * from information_schema.tables where table_name like '%abc%'

where abc is table name