Re: find column name that has under score (_)

that's right. Thanks again all for the help

On Thu, Feb 17, 2011 at 2:09 PM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:

> On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> - Hi all -
> -
> - I am trying to write a query to find all the column names in
> - database that has a underscore in it (_) example souce_id. I know like
> will
> - not work , if where column_name like '%_%' Can you please help?
> -
> - Regards
>
> select table_schema,table_name, column_name from
> information_schema.columns where column_name like '%\\_%';
>
> seems to do the trick.
>
> Dave
>