RE: Fulltext Search help

On Fri, 15 Oct 2004 20:05:57 -0400, "leegold" <[EMAIL PROTECTED]> said: > > On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" ... But maybe there's a better way? I > wish I could do *searchstring* in Fulltext even if the speed was slow as > molasass it's the spec the user wants. Of cours

RE: Fulltext Search help

Try to search in keyword table: select * from keywords WHERE MATCH(keyword_txt) AGAINST ('$radio_keyword' IN BOOLEAN MODE); If it works the problem is in the join. Santino $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$

RE: Fulltext Search help

On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" <[EMAIL PROTECTED]> said: > leegold > on Friday, October 15, 2004 2:32 PM said: > > > I do fulltext search on "work". And AFAIK the search will not find > > "work". For that matter the seach will not find "ingm".

RE: Fulltext Search help

leegold on Friday, October 15, 2004 2:32 PM said: > I do fulltext search on "work". And AFAIK the search will not find > "work". For that matter the seach will not find "ingm". How do I > implement in MYSQL/PHP a search that will have this action? please share the c

Fulltext Search help

I'm running into a limitation in the fulltext search though I think by defination a "fulltext" search will not - or even should not do this, but I'd like to implement this this functionality somehow, given in a text doc. the string: "Yesterday I was superduperworkingman at times." I do fulltex

FULLTEXT Search Help!

Hello, I have FULLTEXT Indexes on 2 columns, Entry and EntryCountry. ( See Below ) mysql> show index from entries\g +-++-+--+---+--- +-+--++--+ | Table | Non_unique | Key_name| Seq_in_index |