query table row for several records.

not sure if this is the correct forum..but...I'm using VS2008 and have a sql query on a button click...
my question is....
is there a way to query my database for more than one record at a time?
 - i.e. "select * from mytable where myrow = "' & textbox1.text & "'"
and have more than one thing i'm looking for in that textbox?
like if the textbox contained
1;2;3;4
could it find all records in that row that are 1 and 2 and 3 and 4 ?
not sure if that is exactly clear, but thanks for any help.
 
...