SQL Syntax Help Needed (Example Also Provided)

[MarkDicken]

Hello,

I have a table called :- tblFruitAll (with 1 field called FruitName)

It has the following records :-

Apple
Orange
Bananna
Cherry

I have a table called :- tblFruitUnwanted

It has the following records :- (with 1 field called UnwantedFruitName)

A*
*range*
*Bananna*
X*
Y*
Z* etc.etc.


I can do a select statement to display the unwanted fruit and it looks like this (in mS Access) :-

SELECT tblFruitAll.FruitName
FROM tblFruitAll, tblFruitUnwanted
WHERE (((tblFruitAll.FruitName) Like [tblFruitUnwanted].[UnwantedFruitName]));

I need to create a SQL Code/Command to delete all the unwanted fruits, leaving only cherry.

Given the simplified version above, what would the 'exact' MYSQL sql have to be ...???

I have looked ay the MYSQL Documentation and not getting anywhere with the LIKE Command.

The reason for my enquiry is because I'm trying to convert an application from Microsoft Access to MYSQL.


Many thanks In Advance ...

Regards

Mark Dicken, England, UK