Hello,
Why score is 0 in my query?
Any suggestions? Seems like fulltext '*' operator produce buggy results.
Alexander
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
mysql> \s
--------------
./mysql Ver 11.19 Distrib 4.0.1-alpha, for pc-solaris2.8 (i386)
Connection id: 9
Current database:
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 4.0.1-alpha
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: cp1251
Server characterset: cp1251
UNIX socket: /tmp/mysql.sock
Uptime: 28 min 19 sec
Threads: 3 Questions: 1047 Slow queries: 0 Opens: 48 Flush tables: 1
Open tables: 2 Queries per second avg: 0.616
--------------
mysql> show indexes from test.logo_text;
*************************** 1. row ***************************
Table: logo_text
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 38347
Sub_part: NULL
Packed: NULL
Comment:
*************************** 2. row ***************************
Table: logo_text
Non_unique: 1
Key_name: ffff
Seq_in_index: 1
Column_name: txt
Collation: A
Cardinality: 38347
Sub_part: 1
Packed: NULL
Comment: FULLTEXT
mysql> select id,txt,match(txt) against('+desi* +service' in boolean mode)
as score from test.logo_text where match(txt) against ('+design +service' in
boolean mode);
*************************** 1. row ***************************
id: 1405
txt: design service
score: 0
*************************** 2. row ***************************
id: 1480
txt: edv-service grafik-design
score: 0
*************************** 3. row ***************************
id: 26570
txt: wave design a full service design agency seth brewer
http://www.wavedesign.com
score: 0
*************************** 4. row ***************************
id: 38847
txt: manucom hands on it service j.shannon design
score: 0
mysql>
---------------------------------------------------------------------
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
