I would like to add TICK:ID to the results in the Ticket ID column. So, instead of getting 1234 as the ticket number I would get TICK:ID 1234

I'm sure this is super easy but I have no SQL skills and this forum has been so helpful.  Thanks in advance.

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


The MySQL function for this is concat:

In this case you need to use the following in the select statement:
concat("TICK:ID ", HD_TICKET.ID)

Answered 02/19/2015 by: chucksteel
Red Belt

  • Thank you so much for your quick reply. It worked perfectly!
Please log in to comment