hi everyone,

i have a msyql database with 1 table (almost 2,000 records) for now. one of the fields of this table is 'cost'. i want a query that results, like the ff:

Cost
2,000 to 3,000
4,000 to 6,000
7,000 to 12,000
.
.
.
greater than 20,000

this is for my search option list. is it possible? a query that returns like this? maybe, except for the last one line.

any help really appreciated...