Re: BETWEEN condition is not working...

[Dev Vivek]

Table Data >>
| sn | station_code | station_name | route_number | arr_time | dep_time | h

alt_time | dis | day |
+----+--------------+-----------------+--------------+----------+------------+--
---------+------+------+
| 1 | DLI | Delhi | 1 | -- | 14:50 | -
- | 0 | 1 |
| 32 | DKZ | Delhi Kishangnj | 1 | 15:01 | 15:03 | 0
2:00 | 3 | 1 |
| 33 | SSB | SHAKURBASTI | 1 | 15:17 | 15:19 | 0
2:00 | 11 | 1 |
| 34 | NNO | NANGLOI | 1 | 15:28 | 15:30 | 0
2:00 | 18 | 1 |
| 35 | BGZ | BAHADURGARH | 1 | 15:42 | 15:44 | 0
2:00 | 30 | 1 |
| 36 | SPZ | SAMPLA | 1 | 15:58 | 16:00 | 0
2:00 | 48 | 1 |
| 37 | ROK | ROHTAK JN | 1 | 16:30 | 16:35 | 0
5:00 | 70 | 1 |
| 38 | KLNK | KALANAUR KALAN | 1 | 16:52 | 16:54 | 0
2:00 | 91 | 1 |
| 39 | BNW | BHIWANI | 1 | 17:25 | 17:50 | 2
5:00 | 120 | 1 |



Query >> select * from trains_with_stations where station_code BETWEEN 'DLI' AND 'BNW';

Result >> Empty set (0.00 sec)