Merge 2 columns into one with UPDATE.
Alright guys, I'm new to this forum and I've been googling for about an hour.
What I am trying to do is (for a database of about 4million records) merge 2 columns:
let's say they are `cola` and `colb`. I need to merge them into `colC` not just for the output (like a concat query), I need them to merge and update into colC.
The reason for this is that I am trying to make it possible to search both colA and colB with 1 string (which for this database, can be a combination of the two).
Hopefully I explained this clearly enough for someone to help.
UPDATE table set colC = concat(cola,colb);
You sir, are a godsend!
Thanks a ton!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread