mySQL: how to compare db?

[Anon]

My mySQL knowledge is almost as bad as my php knowledge. Can you please help:

I have 2 mysql databases:
original_list
new_list

In both lists, the columns are "color" "item" "price"

What is the script that will print out a list to a file all the new RED colored items??

To clarify, here is a sampling of both databases:

original_list database:
red apple
green tree
red car
blue sky

new_list database:
red apple
green tree
green car
red strawberry
red sky

The result I would want to see is:
red strawberry
red sky

As you can see, one of the thing that makes this confusing is the fact that the "red car" from the first database is now no longer in my new_list. But, maybe that's not a problem.

I am hoping for some sort of script in the format of:

mysql_query = (select from new_list where (color == 'red') and not in old_list);

Thank you!!

p.s. as you can see from my "script" above, my mySQL is NOT so good :-)

[Anon]

<?
$result = mysql_query ("SELECT * FROM new_list WHERE color = 'red'");
while ($row = mysql_fetch_assoc ($result)) {
extract ($row);
echo "
color = $color<br>
item = $item<br>
price = $price<br><br>
";
}
?>

[rrijnders]

I don't know if mySQL allows sub-selects but, if it does, you can do this:
<font color=blue>
select * from new_list where color="red" and item not in(select item from old_list where color="red")
</font>

-- Rich