> I want a quick way to find out if there are any rows matching a
> specified value for this indexed field. I dont care how many there
> are or what their properties are, just if there are any or not.
>
> SELECT COUNT(c2) AS num FROM mytable WHERE c2=1234;
>
> Thanks
> Shane
Try: select 1 as yes from mytable where c2=1234 limit 1;
or: select 1 as yes where exists( select 1 from mytable where c2=1234
);
would be interesting to see differences in performance on your data
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards
http://movies.yahoo.com/