homepage Welcome to WebmasterWorld Guest from 54.227.20.250
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Mysql FullText - punctuation marks ?
gublooo

5+ Year Member



 
Msg#: 4030417 posted 10:07 pm on Nov 23, 2009 (gmt 0)

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

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



 
Msg#: 4030417 posted 12:12 am on Dec 18, 2009 (gmt 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)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved