SEO

#1 (**permalink**) 02-28-2008, 06:33 AM

Okay, so I have been gooling all over trying to figure this out. I'm
sure it's easy enough to do, but I can't seem to find it.

All I want to do is figure out the difference between 2 fields. IE:

Field 1= 20
Field 2 =10
Difference between Field 1 & 2 is: 10

Any ideas?

#2 (**permalink**) 02-28-2008, 06:33 AM

If they're both numeric fields, then it's as easy as:
SELECT field1-field2 AS difference FROM table;

and if you always want a positive number:
SELECT ABS(field1-field2) AS difference FROM table;

HTH,
Dan

On 6/6/07, Jason Pruim <japruim@raoset.com> wrote:
>
> Okay, so I have been gooling all over trying to figure this out. I'm
> sure it's easy enough to do, but I can't seem to find it.
>
> All I want to do is figure out the difference between 2 fields. IE:
>
> Field 1= 20
> Field 2 =10
> Difference between Field 1 & 2 is: 10
>
> Any ideas?
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com
>
>

#3 (**permalink**) 02-28-2008, 06:33 AM

Ysgrifennodd Jason Pruim:
> Okay, so I have been gooling all over trying to figure this out. I'm
> sure it's easy enough to do, but I can't seem to find it.
>
> All I want to do is figure out the difference between 2 fields. IE:
>
> Field 1= 20
> Field 2 =10
> Difference between Field 1 & 2 is: 10
>
> Any ideas?
>
>
>
Erm:

SELECT FIELD1,
FIELD2,
FIELD1 - FIELD2 AS DIFFERENCE
FROM TABLE

?

Peter

#4 (**permalink**) 02-28-2008, 06:33 AM

But beware unsigned math, if your columns are unsigned:

create table t( a int unsigned, b int unsigned);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t(a, b) values(0, 100);
Query OK, 1 row affected (0.00 sec)

mysql> select a-b from t;
+----------------------+
| a-b |
+----------------------+
| 18446744073709551516 |
+----------------------+
1 row in set (0.00 sec)

Dan Buettner wrote:
> If they're both numeric fields, then it's as easy as:
> SELECT field1-field2 AS difference FROM table;
>
> and if you always want a positive number:
> SELECT ABS(field1-field2) AS difference FROM table;
>
> HTH,
> Dan
>
> On 6/6/07, Jason Pruim <japruim@raoset.com> wrote:
>>
>> Okay, so I have been gooling all over trying to figure this out. I'm
>> sure it's easy enough to do, but I can't seem to find it.
>>
>> All I want to do is figure out the difference between 2 fields. IE:
>>
>> Field 1= 20
>> Field 2 =10
>> Difference between Field 1 & 2 is: 10
>>
>> Any ideas?
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com
>>
>>
>

--
Baron Schwartz
http://www.xaprb.com/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Figuring out the difference in value between 2 fields