Select a range between

[christa]

hi all

i would select the 6 records before of my value and 6 record after my value.

How can i obtain this result in a single query?

thanks

[bh]

Sadly theres no such a thing as ROWNUM or ROWID in MySQL.

 

Im only guessing, but ive had an idea, and this is the result.

SET @num = 0;
SELECT (@num:=@num+1) AS abc, id, name FROM user__group GROUP BY abc HAVING abc > 2 AND abc < 4

 

@num is the alternate of ROWNUM. You cannot use @num in the WHERE clause, so you need the GROUP BY clause for the HAVING...

[fenway]

I don't think you understood the OP's question.