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
>
>