I need to create a very simple query. I would like to return all the data from one table for a specific item. I want the user to be prompted to enter the item id. Below is an example of the query without letting my user enter the item.
Select * from inventory
where inventory.item_id = 'AQUA-12345'
I just want this to be generic so my user is prompted to enter the item they are looking for.