> Hi folks - > I have looked thru the documentation and the books I have on MySQL - > but have not found anything on how to format column output from select > statements. I'm trying to do several things - > a) if a date is the default of 0000-00-00 then just show a blank > b) for a phone number of 9999999999, format the output as 999-999-9999 > Hints?
Here are some hints. :-) a) http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html b) http://dev.mysql.com/doc/mysql/en/String_functions.html Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
