Filtering

3 posts

[expired user #7479] posted 10 years ago in General

Hey I want to filter between 100 and 1000
I used the "Between" option but no use it can select only between the range 100 to 199

Also not able to use "Intersect" option

Can any one pls help me

10152 posts

ansgar posted 10 years ago

On MySQL or MSSQL?

In MySQL you say

SELECT ... WHERE id BETWEEN 100 AND 1000;

SELECT ... WHERE id >= 100 AND id <=1000;

Do not mix that up with a LIMIT clause:

SELECT ... WHERE ... LIMIT 100, 1000;

This just gives you rows #100 to #1000, depending on the ORDER BY clause or the physical sorting on disk.

Please login to leave a reply, or register at first.