I have the select statement as follows:
select * from table1 where table1.name = (variable);

what I want to do is be abel to change table1.name based on what the user inputs. So how do I use a variable in place of table1.name.