Searching for a particular column in a db - Q?

[jcf27]

Greetings,

I need some help searching for column names.

I'm working with a 500+ table db. How do I go about finding in which table(s) a particular column appears? For example: list all the tables that contain column "first_name".

Thanks in advance!

J

 

[swampBoogie]

select * 
  from information_schema.columns
 where column_name = 'FIRST_NAME'