I'm having some problems with mysql fulltext search.
1) My sql query returns no results (t.com is present in the data)
SELECT * FROM location WHERE MATCH (location_name,location_keywords) AGAINST('t.com' IN BOOLEAN MODE)
Is it a length issue - but "t.com" is more than 4 characters - I'm assuming Mysql removes the fullstop - so it gets two words "t" an "com" - and since both are less than4 - they are ignored - how can I make mysql include the fullstop
2) This maybe related to the first question - I have the following keywords present in 2 different rows of indexed columns
Now when I run the query
SELECT * FROM location WHERE MATCH (location_name,location_keywords) AGAINST('+t.comp' IN BOOLEAN MODE)
Both results show up - I just want the one with "T.comp" to show up and not both.
Has anyone encountered these issues
What should I do.