How to select on the condition A or B

[JudgementDay]

How can I select from a table based on either A or B?

 

In PHP:

if ($row['A'] || $row['B']) {echo "foobar";}

 

In street talk:

If the colour is A or B, then buy it.

 

In MySQL:

?

[php_begins]

if its a query

$query=select fields from tablename where fieldname='A' OR fieldname='B";
while($row=mysql_fetch_assoc($query))
{
   echo $row['fieldname'];
}

 

or something on the similar lines depending on what you need.