where PROD_TITLE = 'FOO' 
where PROD_TITLE in ('FOO','BAR','BAZ')
where PROD_TITLE like '*TEST* or PROD_TITLE like '*BLUE'