Select Code to Download

Table1
------------------
...
5 || Search11
6 || Log_out
7 || LOG

Table2
--------------------------------------------
...
9 || rd_Message_list1_yes ||
10 || 123_Search1_456 ||
11 || 123_Search11_456 ||

Table2
--------------------------------------------
...
9 || rd_Message_list1_yes || 2
10 || 123_Search1_456 || 3
11 || 123_Search11_456 || 5

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