Dibo Chen wrote:
> try SELECT * WHERE x like '3411'.
Like doesn't work either. I tried it.
mysql> select ppn from main where streetnum=3411;
+---------------+
| ppn |
+---------------+
| 01A0030000290 |
| 01A0160000440 |
+---------------+
2 rows in set (3.04 sec)
mysql> select ppn from main where streetnum='3411';
Empty set (2.85 sec)
mysql> select ppn from main where streetnum like '3411';
Empty set (2.88 sec)
Field Type Null Key Default Extra
id bigint(4) PRI 0
ppn varchar(40)
streetnum varchar(80)
streetdir varchar(80)
streetname varchar(80)
streetsuffix varchar(80)
streetnum2 varchar(80)
taxdist varchar(5)
owner1 varchar(40)
--
Tired of Earthlink? Get JustTheNet!
Nationwide Dialup, ISDN, DSL, ATM, Frame Relay, T-1, T-3, and more.
EARTHLINK AMNESTY PROGRAM: Buy a year, get two months free
More info coming soon to http://JustThe.net, or e-mail me!
B!ff: K3wl, w3'v3 r00t3D da [EMAIL PROTECTED] 0h CrAp, INC0M!Ng $%^NO CARRIER
---------------------------------------------------------------------
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
