MySQL Call

[Anon]

I was wondering if there was a way to call a specific field but only reading so many numbers out of it well let me explain

I have a script I want it to call levels these levels are 1-60 and I only want to to count how many rows have numbers between 1 and 10, 11 and 20, 21 and 30, 31 and 40, 41 and 50, 51 and 60 lets say there are 4 people and they all have diffrent levels like one has level 1 and one has level 5 and one has level 15 and one has level 49 I want a call that will count how many entries there are from 1 to 10, 11 to 20 etc. I want it to output the number of the rows which have numbers between 1 to 10, 11 to 20 etc.

Thanks,
Jadnet

Hope this was a good enough explanation.

[nostradamus]

select count(FIELD) from TABLE where FIELD > 0 and FIELD < 11;

the same for FIELD > 10 and FIELD < 21 etc.

I hope I could help, Nostr@damus.

[Anon]

Got it if you take out the count(FIELD) and put in the * it works perfect

EXAMPLE: select * from TABLE where FIELD > 0 and FIELD < 11

where TABLE is your table name
and
where FIELD is the a field in the bable

and the numbers are what numbers to look through so 0 and 11 would mean it looks for numbers between 0 and 10