Advanced MYSQL Query

[Judahnator]

I am alright at simple queries, i have never needed to do anything too advanced though.

 

Whenever i need to do something complicated, i ususally write a script to do it instead of writing an advanced query. I cannot do that here for reasons.

 

 

What i have:

Cell A => "this",Cell B => "is a",Cell C => "string",

What i need:

Cell D => Cell A + " " + Cell B + " " + Cell C

Or, more simply:

Cell D => "this is a string"

How can I accomplish this?

[prolemur]

SELECT CONCAT(cell_a, " ", cell_b, " ", cell_c) AS 'cell_d'

FROM table;

[Judahnator]

 

SELECT CONCAT(cell_a, " ", cell_b, " ", cell_c) AS 'cell_d'

FROM table;

 

 

 

Ill give it a shot and let you know how it goes

[prolemur]

Ill give it a shot and let you know how it goes

Alright, I think this is what you are looking for anyways

[Judahnator]

Alright, I think this is what you are looking for anyways

 

Thanks a ton for your help!

 

The final query I ended up with was this:

UPDATE `fortusrealty_com`SET `address_fixed` = (    SELECT CONCAT(`field_LIST_31`," ",`field_LIST_33`," ",`field_LIST_34`," ",`field_LIST_37`," ",`field_LIST_35`)    AS `address_fixed`)WHERE `address_fixed` != ""LIMIT 100

Couldnt have done it without your help