selecting multiple rows SQL

[seidel]

How do I select multiple rows from a table

table
document_number | written_by
AM010101 | christopher
PP010101 | jennifer
AS010101 | jeff
XX010101 | jerovsek

SELECT *
FROM table
WHERE document_number = ?

I want to select
AM010101
PP010101
XX010101

I know this is simple, can not figure it out

Thanks

[kennethl]

You could do this with three different queries:

SELECT FROM table WHERE document_number = 'AM010101'
SELECT FROM table WHERE document_number = 'PP010101'
SELECT * FROM table WHERE document_number = 'XX010101'

Or in one query:

SELECT * FROM table WHERE document_number = 'AM010101' OR document_number = 'PP010101' OR document_number = 'XX010101'

[Anon]

You can also use
SELECT * FROM table WHERE document_number in ('AM010101','PP010101','XX010101')