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 Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/ Share on other sites More sharing options...
fenway Posted February 6, 2007 Share Posted February 6, 2007 Define "not work"? Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-178473 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 Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-178546 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. Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-178562 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. Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-178593 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). Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-178597 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)]. Link to comment https://forums.phpfreaks.com/topic/37331-why-doesnt-this-query-work/#findComment-179202 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.