problem with FULLTEXT INDEX

[vineel kota]

Hi all,
I executed the following query
select * from tbl_name where column_name like 'W%';
It returned 540 records.

Total number of records for the query is 1 million records.
Data type for the column is varchar(10).

I have created fulltext index on the column_name which is varchar data type.
Then I tried the following query

select * from tbl_name where match(column_name) against('W*' IN BOOLEAN MODE);
It returned 174 records.

Isn't it wierd? Why is it returning 174 records. It should return 540 right?

Also, it returned the rows with values for column_name like ADD-W3455 and TW3456.

I searched the whole mysql reference manual But I couldn't find the syntax where it will return the same rows with full text index search as it returned using LIKE SQL statement.

I am using mysql 4.1.12 on red hat linux.

Any help is appreciated.

Thanks for your time,
Vineel