fetching a row based on 3 conditions

[fizzwizz]

If I wish to return the results from a table where colour = blue I would do

$results = mysql_query("SELECT * FROM mytable WHERE colour = 'blue'",$link_id);

$query_data = mysql_fetch_row($results)

How then could I return result from where colour = blue AND letter = A AND number = 2?

Thanks ... Fizz

[drawmack]

exactly the way you typed it above the words AND and OR mean the same thing in sql that they mean in english.

[fizzwizz]

Thaks again Drawmack.
Best wishes ... Fizz