My sql find table field or column name in your database

 You can  Find my sql fieldname is it available in your database easily by run the follwing sql query in your database.

SELECT * FROM   information_schema.columns WHERE  table_schema = 'database_name' AND column_name IN ( 'field_name' );

Note : In the above query just you should edit 2 things only

          1. 'database_name' = your database name

          2. 'field_name' = column name which you search

           

Enjoy it ....