$query = "SELECT Table1.value, Table2.value1 FROM Table1,Table2 WHERE Table2.value1 LIKE CONCAT('%',Table1.value,'%')"; $result =mysql_query($query) or die(mysql_error()); while(@row = mysql_ftech_array($result)) { $updatetable2= UPDATE Table2.value2 SET Table2.value2 =(@Table1.value); }