Php-mysql: query with 2 'Where's on the same column?

1

Hey there,
Anyone know if it is possible to make a query function with multiple WHERE clauses that reference the same column?
I have no problem with multiple WHERE clauses referencing different columns, but my query fails when I add in that duplicate reference…Here’s some code:


$result = mysql_query("select * from {$table} WHERE Registration.Division = '$Division' && Registration.Division = 'Open' && Event = '$Event' ORDER BY Rorder ASC");

Maybe I am using the wrong syntax. But if I drop that second reference to ‘Registration.Division’, it works fine.
But of course, I need it!

Thanks,

Chris