SELECT within NUMERIC RANGE

[xProteuSx]

Is there a way to do this using mysql?

 

SELECT * WHERE year < 2000 AND year > 1900

 

for example?

[kicken]

Yes, the condition you posted as your example is valid:

 

WHERE field > minimum AND num < maximum

 

You could also use the BETWEEN operator to do a range search.

 

WHERE field BETWEEN minimum AND maximum