Copy link to clipboard
Copied
I have a page that displays data from a mysql database and I can successfully use one filter however I need to filter the recordset by two different fields. Is this possible in the advanced settings? Any help is awesome. Thanks a lot.
Copy link to clipboard
Copied
SELECT * FROM table WHERE field1 = 'whatever' AND field2 = 'whatever2'
Sure - you can do that in the advanced section. Just add another filter to the WHERE.
Copy link to clipboard
Copied
***ANSWERED***
...as far as i'm concerned.
THANK YOU to Murray for your clear, concise, & perfect answer. i've been searching & reading for hours on how to do this, and ALL the other solutions so far were so convoluted and hard to understand. but yours was simple and exactly what i needed.