I want to update a column using as follow

Table structure

Table name=A
a1 varchar( contains Name)
b1 varchar(require code from d1 where a1 matches with c1)
c1 varchar(contains Name)
d1 varchar(code corressponding to c1)

Now i want to update b1 as such where value a1 =c1 then corressponding value should be updated

How can we do ?

This is a link to a description of the MySQL update statement - have a look at how to use the where clause. It's amazing how useful it can be.

Mike