mgcom Posted February 6, 2007 Share Posted February 6, 2007 Why does this query not work? I have my fulltext indexes already defined, I dont get it! SELECT *, MATCH(desc,name) AGAINST ('search terms') AS R FROM items WHERE MATCH(desc,name) AGAINST ('search terms') AND type=1 please help Quote Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2007 Share Posted February 6, 2007 Define "not work"? Quote Link to comment Share on other sites More sharing options...
artacus Posted February 6, 2007 Share Posted February 6, 2007 Broken, busted, damaged, defective, defunct, boogered, faulty, imperfect, dysfunctional, kaput, foobar'd. Now that we got that out of the way, would you help the man Quote Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2007 Share Posted February 6, 2007 Ok then... my guess? "desc" is a reserved keyword. Quote Link to comment Share on other sites More sharing options...
artacus Posted February 6, 2007 Share Posted February 6, 2007 See, you're just so d@mn smart when you apply yourself. Quote Link to comment Share on other sites More sharing options...
effigy Posted February 6, 2007 Share Posted February 6, 2007 To clarify: (1) don't use reserved words; and (2) if you have to, surround them with `backticks` (shift-tilde). Quote Link to comment Share on other sites More sharing options...
fenway Posted February 7, 2007 Share Posted February 7, 2007 (3) You never "have to"... so don't [see (1)]. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.