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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]