Retrieves rows that contain any or all the values in the specified data. Can be used with operators <, >, = to collect specific rows.

 

Example:

SELECT * FROM Customers_dataflex WHERE customerstate = 'UT' OR customerID = 'anthb'