Mysql FullText - punctuation marks ?

[gublooo]

Hello
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
- "t.comp"
- "comp"

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.

Thanks

[whoisgregg]

Welcome to WebmasterWorld, gublooo!

Did you get this sorted out? If not, you might try simply wrapping the t.com in double quotes:

SELECT * FROM location WHERE MATCH (location_name,location_keywords) AGAINST('+"t.com"' IN BOOLEAN MODE)