Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Mysql FullText - punctuation marks ?

10:07 pm on Nov 23, 2009 (gmt 0)

New User

5+ Year Member

joined:Dec 19, 2007
posts: 8
votes: 0

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.


12:12 am on Dec 18, 2009 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
votes: 0

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)

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members