Re: help with fulltext search

Stefan, On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken wrote: > Hello, > > I am bit puzzled about combining mysql fulltext search into our > current search: > > I am not able to combine a fulltext search with other selections, > please see http://pastebin.com/m23622c39 for full details. The > momen

help with fulltext search

Hello, I am bit puzzled about combining mysql fulltext search into our current search: I am not able to combine a fulltext search with other selections, please see http://pastebin.com/m23622c39 for full details. The moment I am using "...where a=2 OR match (bla) AGAINST ('foo') mysql is not u

Re: Need help with fulltext search and left join

For me, it looks as if you confused the order of join and where. It should be: select ... from ... join ... where ... order by ... Stefan Am Sunday 23 October 2005 13:21 schrieb Grant Giddens: > Hi, > > I keep getting errors on this query and I'm not sure > why. I'm using mysql version 4.0.22.

Need help with fulltext search and left join

Hi, I keep getting errors on this query and I'm not sure why. I'm using mysql version 4.0.22. Any ideas? SELECT pn_coupons_store.store_name, pn_coupons_store.store_name_short, pn_coupons_coupons.store_id, pn_coupons_coupons.coupon_id, pn_coupons_dealtype.dealtype_name, pn_coupons_coupons.co