Like '%ANYTHING%' with all fields in table

I think I know the answer to this already but thought I'd make sure. Is it possible to do a SQL query with a "Like" match on all fields in the table without listing each table?

So instead of:

where lastname like '%DOE%' or firstname like '%DOE%' or address like '%DOE%'

You could do something like

"any fields" like '%DOE%'

I don't think is implemented yet , or you can add it to features list if you want

I would like something like that that will search in all tables




maybe you can do it in a stored procedure

something like

1. read all table fields names
2. put them and execute an



the same with multiple tables
1.select all tables names
2. put them and execute and