Inserting variable into new column

[mikebyrne]

I currently have a database of names and addresses which looks like this:

 

,1,Caxxan,Cathy,Wxxxde,Ardreigh,Axy,Co.xxxe

,2,Caxxan,Liam,Wxxxde,Ardreigh,Axy,Co.xxxe

,3,Caxxan,Margaret,Wxxxde,Ardreigh,Axy,Co.xxxe

 

I want to run a piece of php that will insert "The $Sname Family" in a new column where $Sname is the varible of the surname of that row.

 

Any idea how I can code this??

 

 

[PFMaBiSmAd]

Assuming mysql, execute this query (substituting your actual column names) to update your new column with the concatenation of - 'The ', your Sname column values, and ' Family' -

UPDATE your_table SET your_new_column = CONCAT('The ', Sname, ' Family')