How can SQL determine if a certain value exists in an array?

In SQL, we can use the IN keyword to determine if a certain value exists in an array. For example:

SELECT * FROM table_name WHERE column_name IN (value1, value2, value3);

This SQL query will return all records in the table_name table where the column_name column contains value1, value2, or value3. If any of these values are present in the array, the record will be returned.