Query database for multiple post types

I’m wondering if anyone can help me figure out the proper syntax for doing a SELECT query WHERE post_type = “multiple post types here”?

I am unsure if it should be done as an OR statement, or if it is possible to insert an array ie post_type = array(post, page … etc.)
any help would be greatly appreciated.

I’m curious how the %s functions exactly as well if anyone is up to indulging me … as in post_type = %s. Sorry for my self taught ignorance. I’m reading everything I can get my hands on, but, all I have come across in regards to %s is that it represents a string?