On Fri, 22 Jun 2001, Thomas J Keller wrote:
> select zip, city, county from zipcodes where zip between 68400 and 68500;
>
> here is a portion of the garbled output:
>
> |68442 | STELLA | RICHARDSON
> |43 | STERLING | JOHNSON
> |444 | STRANG | FILLMORE
> |5 | SWANTON | SALINE
> +-------+------------------+-------------+
Not too sure what could be wrong, but I did something like this:
mysql> select * from country where contid between 10 and 20;
+----+--------------+--------+
| id | country | contid |
+----+--------------+--------+
| 9 | Benin | 10 |
| 10 | Bermuda | 11 |
| 11 | Birmania | 12 |
| 12 | Bolivia | 13 |
| 13 | Botswana | 14 |
| 14 | Bulgaria | 15 |
| 15 | Burkina faso | 16 |
| 16 | Burundi | 17 |
| 17 | Buthan | 18 |
| 18 | Cambogia | 19 |
| 19 | Camerun | 20 |
+----+--------------+--------+
11 rows in set (0.00 sec)
It works!
My table is:
mysql> desc country;
+---------+-------------+------+-----+---------+----------------+---------------------------------+
| Field | Type | Null | Key | Default | Extra |
Privileges
|
+---------+-------------+------+-----+---------+----------------+---------------------------------+
| id | int(5) | | PRI | NULL | auto_increment |
select,insert,update,references |
| country | varchar(35) | | MUL | | |
select,insert,update,references |
| contid | int(5) | | UNI | 0 | |
select,insert,update,references |
+---------+-------------+------+-----+---------+----------------+---------------------------------+
Similar to yours. Does your table hold any data less that 65000?
Try select zip, city, county from zipcodes where zip>=68400 and zip<=
68500;
Regards
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php