选择包含特定列的所有表

I have around 300 tables in my database . I want the tablenames containing tha columns sname,dtcreatedat,dtmodifiedat,ixlastmodifiedby and fstatus . Presently I am checking manually each of the table. Which command can be used in mysql to do this?I have around 300 tables in my database . I wan