Hi!
I made a head table like this:
##
>create table SECURITIES (
SID varchar(16) not NULL,
NAME varchar(255) not NULL,
MARKET varchar(8) not NULL,
TICKER varchar(8) not NULL,
LAST_PRICE float not NULL,
BID float,
ASK float,
BIDSIZE int unsigned,
ASKSIZE int unsigned,
PRICE_CHANGE float,
PRICE_CHANGE_PST float,
HIGH float,
LOW float,
VOLUME int unsigned,
CHANGED datetime not NULL,
LAST_PRICE_DELAYED float not NULL,
CHANGED_DELAYED datetime,
CREATED datetime not NULL,
PRIMARY KEY (SID),
INDEX (MARKET),
INDEX (TICKER),
INDEX (LAST_PRICE),
INDEX (LAST_PRICE_DELAYED),
INDEX (CHANGED),
INDEX (LAST_PRICE) ) type=HEAP;
##
Then I insert 216 rows of securities where MARKET = 'OSE'.
When I try to select from SECURITIES like this:
> select * from SECURITIES where MARKET='OSE';
the query only responds with 1 row. ( the last in the next listing )
but if I do this:
> select * from SECURITIES where MARKET like '%OSE';
it resonds with all the 216 rows.
--
Tom Vatland
mob: +47 93683350
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
