How to simply add ' and " to numeric values for height(inch) format?
mysql&gt; select concat(LEFT(73, 1),'\'',SUBSTR(73, 2),'\"') converted;
+-----------+
| converted |
+-----------+
| 7'3"      |
+-----------+