> i have list where I would like make a select, this list look like this > > id Properties Others > ***************** > 1 1 sssssss > 2 2 sss > 3 2 aaaaa etc... > 4 2 > 5 2 > 6 1 > 7 2 > 8 2 > 9 1 > ...... > imagine that from this list I only want to select those registers that > propiertis are 1, but now all the registers but only 2 each time. For > example, i got id 1, so i would like to select only registers > with 1 and 6, > and if i starts from id 6, i should be able to select 6 and 9 and no more. > > How can I do that? >
SELECT * from list WHERE properties = 1 AND id >= [starting ID] LIMIT 2; Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
