List:General Discussion« Previous MessageNext Message »
From:tk Date:December 31 2003 9:31pm
Subject:Re: FULLTEXT Search and Hyphens
View as plain text  
Sorry about this,

> The only way to search for kk-4835 is to do the
> search
> in Boolean mode and put things in quotes ->
> "kk-4835"
> So your query would look like this:
> 
> > SELECT * FROM ms_items
> > where MATCH (it_mnfgID, it_title, it_descrip)
> > AGAINST ('"kk-4835"' IN BOOLEAN MODE )

Put things in quotes not question marks. 
TK

__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
Thread
FULLTEXT Search and Hyphensmichael elston31 Dec
  • Re: FULLTEXT Search and HyphensDan Nelson31 Dec
  • Re: FULLTEXT Search and Hyphenstk31 Dec
    • Re: FULLTEXT Search and Hyphenstk31 Dec
  • Re: FULLTEXT Search and HyphensThomas Spahni5 Jan