Mysql 7.3: WHERE ... BETWEEN
Written by: maffelu , 2009-04-16 21:16:17
|--------------------+--------------------+--------------------|
|Name |Age |Gender |
|____________________+____________________+____________________|
|Bob 34 Male |
|Silvia 67 Female |
|Magnus 24 Male |
|Lisa 32 Female |
+--------------------------------------------------------------+
SELECT column
FROM table_name
WHERE column
BETWEEN condition1 AND condition2
SELECT *
FROM person
WHERE Age
BETWEEN 20 AND 40
|--------------------+--------------------+--------------------|
|Name |Age |Gender |
|____________________+____________________+____________________|
|Bob 34 Male |
|Magnus 24 Male |
|Lisa 32 Female |
+--------------------------------------------------------------+
There are no comments on this article.
If you have any question or just want to leave a message, just fill out the form below!
Your e-mail will not be visible in your post, it is for validation reasons only
Maffelu
Creator and admin of MorkaLork.com.
Started programming in HTML back when frames and tables was the way to design a page, moved on to Pascal/Delphi, PHP, javascript/jQuery, VB.NET/C#, Java and C++.
Currently studies .NET (in general) focusing on ASP.NET.