Fixed size(lenght) from my SELECT output data

[Lars Skoog]

Hi !!

Is there away to have the output from the SELECT command to give me fixed sized columns?.
The reason for this is that i'll would like to do some data manipulation through some unix scripts using cut -c statements. The SELECT command produce a fairly "messy" output when a columns is sometimes empty and sometimes populated.


EX: SELECT id, fname, lname, email FROM users ORDER BY id INTO OUTFILE '/home/las/output.LOG';

Best Regards Lars Skoog