[RESOLVED] SHOW TABLES containing a field name?

[perpetualshaun]

I am working on some changes for a client, and we'll be altering the users tables as we go along. So from the one admin screen I want to get a list of the DB tables w/ the name '*_users' AND which contain one of the new fields, user_name.

This doesn't work, but something like this:

SHOW TABLES LIKE '%_users' AND COLUMN user_name

Does anyone know of a way to do something like that in one query? I know that I could get all the tables in a query, then loop through them an look for that field, but trying to find a one-step method here.

Thanks,
Shaun