|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
August 26th, 2005, 05:28 AM
|
|||
|
|||
|
MYSQL / MSSQL behaviours in "Where between"
I neet some Help for MySQL MSSQL.
There is a parameter in the "WHERE" part called "in Between". for example: ... WHERE in Between 1 to 3 MY SQL prints all Values from 1 to 2 - exklusive the 3 MS SQL prints all Values from 1 to 3 - inklusive the 3 Is there a "between" parameter for MYSQL that makes the Output like MS SQL? I know it is possible to use the following command: ">=1 AND <= 3" but I need the Result for "in Between". Thanx for your help. Excuse my english. Its been long ago since I spend at High School for a year in Alaska 
|
|
#2
August 26th, 2005, 10:53 AM
|
|||
|
|||
|
MySQL's BETWEEN is inclusive (but there's no 'in'):
Code:
SELECT * FROM table WHERE id BETWEEN 1 AND 3 will retrieve rows with id 1, 2, and 3.
__________________
"A pawn is the most important piece on the chessboard -- to a pawn"
|
|
| Viewing: Dev Articles Community Forums > Databases > Database Development > MYSQL / MSSQL behaviours in "Where between" |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
