mysql - Select ___where __LIKE ___ -

i want select tables don't contain character _ database, used request :

select table_name  information_schema.tables  table_schema="db_name" , table_name not '%_%';  

but doesn't seem work.

the underscore (_) single character wildcard in sql's like operator. if want treat regular charater, you'll have explicitly escape it:

select table_name    information_schema.tables   table_schema='db_name' , table_name not '%\_%' escape `\`;