Filter Recordset more than once?

[cwhazzoo]

I am using PHP MySQL

Hi I have a recordset being filtered using the code below:

$query_CurrentCVIP = "SELECT * FROM Community_Profiles WHERE `ACCESS` = 'CVIP'";

Is their any way to filter it by checking more than one value. For example:

WHERE 'ACCESS' = 'CVIP' and 'RANDOM' = "Test'

Is something like that possible?

Thanks for the Help

[bregent · Accepted solution]

Of course. A SQL where clause can contain multiple tests using either the AND or OR operators.