SELECT * FROM your_table WHERE your_number_field REGEXP "\." > -----Original Message----- > From: Beauford.2003 [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 12, 2002 3:26 AM > To: [EMAIL PROTECTED] > Subject: Displaying output from MySQL > > > Hi, > > Not sure if this is a PHP of a MySQL question, so I am > sending it to both groups. Basically I have a list of numbers > with two decimal places in the MySQL database, but I only > want to display some of them with the decimal points. > > i.e. > > 70 (not 70.00) > 87 > 51.5 > 46.75 > 12 > 29 > 5.5 > -1 > 45 > > I know it's probably a weird request, but any thoughts on how > one would do this either through PHP or MySQL. > > TIA > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php