You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious. Enter the IN statement. You could use it like this:
SELECT * FROM
TABLE
WHERE STUDENTID IN
(
STU123,
STU456,
STU789,
STU1003,
STU10
)