On Friday 04 October 2002 11:04, Paul DuBois wrote:
> At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
> >If I have a table,
> >
> >Name VARCHAR(100)
> >L DOUBLE
> >a DOUBLE
> >b DOUBLE
> >
> >and execute the incredible
> >
> >SELECT * FROM Colors WHERE
> >SQRT(
> > SQ(
> > ABS( L - 45.5 )
> >
At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
>If I have a table,
>
>Name VARCHAR(100)
>L DOUBLE
>a DOUBLE
>b DOUBLE
>
>and execute the incredible
>
>SELECT * FROM Colors WHERE
>SQRT(
> SQ(
> ABS( L - 45.5 )
> ) +
> SQ(
> ABS( a - 13.2 )
> ) +
> SQ(
> ABS( b + 23.4 )
>
If I have a table,
Name VARCHAR(100)
L DOUBLE
a DOUBLE
b DOUBLE
and execute the incredible
SELECT * FROM Colors WHERE
SQRT(
SQ(
ABS( L - 45.5 )
) +
SQ(
ABS( a - 13.2 )
) +
SQ(
ABS( b + 23.4 )
)
) < 2.5 ;
Could MySQL benefit in any way by indexing the L,a,
