Hi,
I am using mysql 5.0.22 on Redhat Linux. I have a table (named EA) with following structure
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| filename | varchar(300) | NO | PRI | NULL | |
| title | mediumtext | NO | | NULL | |
| content | longtext | NO | MUL | NULL | |
| create_date | date | NO | | NULL | |
| asc_size | int(200) | NO | | NULL | |
| pdf_size | int(200) | NO | | NULL | |
| wpd_size | int(200) | NO | | NULL | |
| filename_big | varchar(200) | NO | | NULL | |
| filename_orig | varchar(200) | NO | | NULL | |
+---------------+--------------+------+-----+---------+-------+
I have fulltext indexing on "content". I am using this sql statement to get the score
SELECT *, MATCH(content) AGAINST ('export') AS score FROM EA WHERE MATCH(content) AGAINST ('+export' IN BOOLEAN MODE) ORDER BY score DESC;
I am getting 0 (zero) score in results. Column named 'content" has ASCII content in it. Table has 58 rows.
Here are some table stats
Format dynamic
Collation latin1_swedish_ci
Rows 58
Row length 108,542B
Row size 134,937 B
Table Space usage
Type Usage
Data 6,148 KiB
Index 1,495 KiB
Total 7,64 3KiB
Am i missing some things here? I have dropped table and recreated everything from scratch couple of times.
Thanks in advance.
