that's right. Thanks again all for the help On Thu, Feb 17, 2011 at 2:09 PM, David Kerr <d...@mr-paradox.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 >
