Base 4.4.3 in Ubuntu.
I have a table that I would like to append “Mhz” to the end of a result.
Here is my SQL query:
SELECT “Virginia”.“FCC Callsign” “VA Call”, “West Virginia”.“FCC Callsign” “WV Call”, “West Virginia”.“Frequency Output”, “West Virginia”.“Tag” FROM “Virginia”, “West Virginia” WHERE “Virginia”.“Frequency Output” = “West Virginia”.“Frequency Output”
I want to append it to the frequency queries.
You can use “West Virginia”.“Frequency Output”||‘Mhz’
or
CONCAT(“West Virginia”.“Frequency Output”,‘Mhz’)
String constants are in single quotes to distinguish them from fields which are enclosed in double quotes.
n.b. CONCAT only take 2 arguments so if you want to string together 3 or more fields you have to nest them e.g.
CONCAT(CONCAT(“Field1”,“Field2”),“Field3”))
Rewite your SQL as:
SELECT “Virginia”.“FCC Callsign” “VA Call”, “West Virginia”.“FCC Callsign” “WV Call”, “West Virginia”.“Frequency Output”||’Mhz’, “West Virginia”.“Tag” FROM “Virginia”, “West Virginia” WHERE “Virginia”.“Frequency Output” = “West Virginia”.“Frequency Output”
or as
SELECT “Virginia”.“FCC Callsign” “VA Call”, “West Virginia”.“FCC Callsign” “WV Call”, CONCAT(“West Virginia”.“Frequency Output”,’Mhz’), “West Virginia”.“Tag” FROM “Virginia”, “West Virginia” WHERE “Virginia”.“Frequency Output” = “West Virginia”.“Frequency Output”
Where do I put it?
You put it in the list of fields selected. In the example above
CONCAT(“West Virginia”.“Frequency Output”,’Mhz’)
(Well, I would prefer ‘MHz’, but I am a grumpy old man.)