WHERE statement question?

[Anon]

I have a table that contains multiple columns (name, address, city, cat1, cat2). Is it possible to do a SELECT statement like this.

Formon previos page value = $shopping

SELECT name, address from table1 WHERE cat1 LIKE '%web%' AND (shopping LIKE '%$shopping%' OR shopping LIKE '%$shopping%')

[scoppc]

just observe the query it generates by echo.

$query="SELECT ... blah ... blah ...";
echo $query;

you'll be able to answer whether it can be done.