How to simply add ' and " to numeric values for height(inch) format? I have a height field that contains two numeric values and I need to add ' and " at the end of each number to display the value as height(inch) format.
It seemed simple but couldn't find answers that I was looking for. 

Height -> Height(inch)

72     ->   7'2"

65     ->   6'5"

68     ->   6'8"
.            .
.            .
.            .
.            .

Any suggestions? I am very new to sql and and would appreciate any help I can get!!
mysql&gt; select concat(LEFT(73, 1),'\'',SUBSTR(73, 2),'\"') converted;
+-----------+
| converted |
+-----------+
| 7'3"      |
+-----------+