user supplied variables

[Jim Lann]

I am such a newbie at this, but here goes:

I'm trying to create a select statement in "views" that would allow users to query all of the tables based on any attribute in each of the tables.

for instance:

select * from table1,table2,table3,table4
where (user supplied field variable) = (user supplied variable. must be an enry in one of the fields in at least one table);

That's the entire query. Any ideas?

Oh, yeah, I'm using MySQL 5.x

Thanks