Simply do it like with math fields:
SELECT count(*) WHERE order_column < '$mid_row_value'
Marco Bleeker wrote:
At 15:38 20-11-02 +0100, you wrote:
I don't think this can be done without ordering the selection first.
Then you can do it:
1. you need to find out the value your middle row has in
I don't think this can be done without ordering the selection first.
Then you can do it:
1. you need to find out the value your middle row has in the order column,
2. count rows with smaller value in the order column than your middle
row, this is its offset
3. now you can (using the offset) selec
And how would I find out which portion (row number) the row would be in,
that I would like to see in a listing?
Hello, how would I go about listing a portion of a MySQL table, without an
overall selection criterium? I have a unique index field, but it's a string
and not autoincremented (but ma
3 matches
Mail list logo
