How to check table is exists in database mysql

This is another way to check if table exists or not.

  SHOW TABLES LIKE 'TableName';
Or Alternatively you can use like this...
SELECT EXISTS(
   SELECT * FROM information_schema.tables 
   WHERE table_schema = 'database' 
   AND table_name = 'table'
);
It actually return a boolean.