Topic on Talk:Quarry/Flow

Kindly, Have a look at https://quarry.wmflabs.org/query/19420. How can i insert ~ symbol inbetween the Q-number and the label?

You can just prepend tildes to the second column:
CONCAT("Q",ips_item_id),CONCAT('~ ',ips_site_page)

or to append them the first column:
CONCAT("Q",ips_item_id,'~')

but if you need 3 columns, you can use:
CONCAT("Q",ips_item_id), CONCAT('~'), ips_site_page

Note, that in second XXN's example, you can use '~' instead of CONCAT('~')