13

I have a table with a column that is TEXT type. In the column are numeric characters. What I'm trying to achieve is to wrap those characters in double quotes.

EXAMPLE:

NAME     ID     QTY
Apples   A1     1
Oranges  O1     1
Foo      F1     0

IDEAL OUTPUT:

NAME     ID     QTY
Apples   A1     "1"
Oranges  O1     "1"
Foo      F1     "0"

I attempted to run the following SELECT statement but it didn't give me the result I was expecting. Perhaps you can guide me in the right direction?

SELECT `qty`, CHAR('"'|| qty ||'"')
FROM `myTable`;

Thank You

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536
Bard
  • 133
  • 1
  • 1
  • 6

1 Answers1

21

Use the CONCAT function

SELECT NAME,ID,CONCAT('"',QTY,'"') QTY FROM `myTable`;

If you want single quotes, use the QUOTE function

SELECT NAME,ID,QUOTE(QTY) QTY FROM `myTable`;

Give it a Try !!!

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536