I am trying to write a script that will do a sql statement. But in the sql I will have a list (1,2,3,4).
How would I go about asking for the input from the user running the script, and then transferring that back into the list as say ($var1,$var2,$var3)?
It would be somewhat like this:
Enter numbers:
1,2,3,4,5,6,7,8 (I need these numbers to be the variables)
Select *
from person
where nbr in ($var1,$var2,$var3,$var4);
Any and all help is greatly appreciated! Have a good day!