I've been trying to do this for a while, searched all over the Googlenet for the answer and have come up with nothing.

There are certain sections of my site where I only want to display MySQL entries that correspond with two or more possible values of a field. That sounds really convoluted, so I'll just write up what I have.

$queryRecordset = "SELECT * FROM tablename WHERE fieldname=('value_a' || 'value_b' || 'value_c')";

Obviously, this isn't working. I've tried replacing || with && and commas, as well as with and without brackets. I'm not the most skilled with MySQL syntax, so I'm just working with what I know. Any help would be immensely appreciated.

WHERE fieldname = 'value' OR fieldname = 'value2' ...

GAH! I swear I already tried that and it didn't work. Either way, it's working now. Thanks muchos bunchesos.

More readable, in my opinion, is the in() operator

SELECT * 
FROM tablename 
WHERE fieldname in('value_a', 'value_b', 'value_c')

But in the end, it's the same than using OR keywords.