Delete all records starting in R

[NZ_Kiwis]

$result2 = mysql_query ("DELETE FROM r_CompTables WHERE CompID = R??") or die("DELETE error: ".mysql_error());

I have this code but I want it to delete anything start in R. R will be followed with a number so it could be R5 or R91

How can I do this?

[cgraz]

delete from r_CompTables where CompID like 'R%'