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,
&
Hi.
On Thu 2002-12-12 at 02:25:51 -0500, [EMAIL PROTECTED] wrote:
> Hi,
>
> Not sure if this is a PHP of a MySQL question, so I am sending it to both
> groups.
Usually it is preferred that you send it only to the list which is
more appropriate first (toss a coin, if you must ;-) and only if you
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
