I have an INT field in my table, which I'd like to select as a zero-padded string. So for example, 8 would come out as 008, 23 as 023 and so on. Is this possible in a MySQL query?
008
023