https://www.webmaster-forums.net/crss/node/1037476 en https://www.webmaster-forums.net/web-database-development/operators-mysql-query#comment-1214817 <p>Okay, thanks. Sorry I left out the Select * bit - just didn't think it was relevant...</p> Fri, 09 Feb 2007 20:02:17 +0000 Megan comment 1214817 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/operators-mysql-query#comment-1214815 <p>It would work something like this...</p> <p>SELECT *<br /> FROM sometable<br /> WHERE year &gt;= 2<br /> AND year &lt;= 4</p> <p>The = after the &lt; or &gt; makes it inclusive, rather than exclusive. With the second one you mentioned, it would only grab ones where year was 3. Assuming it was an integer and not a float, of course.</p> Fri, 09 Feb 2007 19:52:21 +0000 timjpriebe comment 1214815 at https://www.webmaster-forums.net