Welcome to WebmasterWorld Guest from 54.162.167.40

Forum Moderators: open

Message Too Old, No Replies

Mysql FullText - punctuation marks ?

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

5+ Year Member



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

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

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



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)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month