SQL Concatenate String as a Result

Question

Let's say I have the following query:

SELECT anInteger FROM table; 

How to make this request a concatenation of the front-panel URL, so each returned line becomes:

 'http://aurl.com/something?q=anInteger' 

Note that this must be the query itself that performs the concatenation - obviously in a situation where you get results in a language that you must concatenate in a language.

Answer 1

You would use something like:

 SELECT 'http://aurl.com/something?q=' + cast(anInteger as varchar) FROM table; 

Answer 2

it will depend on the DBMS used:

MySQL:

SELECT concat (anInteger, "your line goes here") FROM table;

PostgreSQL:

SELECT anInteger || "your line goes here";

Oracle:

Same as PostgreSQL