FULLTEXT not working - Codewalkers

Codewalkers Forums Sponsor:

September 30th, 2003, 11:20 AM

diogoacs

Join Date: Apr 2007

Location: Brazil

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

FULLTEXT not working

hey guys!

I'm trying to make a "fulltext" search type, but it isn't working

the query (i echo it off) is:

php Code:

Original - php Code
$somequery = sprintf("SELECT * FROM table WHERE MATCH(Field1,Field2) Against('%s') ORDER BY Field3",$search);

 
$somequery = sprintf("SELECT * FROM table WHERE MATCH(Field1,Field2) Against('%s') ORDER BY Field3",$search);

When i execute this query it return a empty set, but it's wrong...

And YES!!! it has a "FULLTEXT search (Field1,Field2)" on the "SHOW CREATE TABLE table"...

What's wrong?!

Thanx!

September 30th, 2003, 02:05 PM

tkarkkainen

Moderator

Join Date: Apr 2007

Location: Finland

Posts: 2,326

Folding Points: 15677 Folding Title: Novice Folder

Time spent in forums: 6 Days 9 h 32 m 40 sec
Reputation Power: 4

RE: FULLTEXT not working

Notice that if your FULLTEXT search returns more than half of the rows in your table, it returns zero rows.

October 1st, 2003, 03:39 AM

zombie

Codewalkers Intermediate (1500 - 1999 posts)

Join Date: Apr 2007

Location: serbia

Posts: 1,876

Time spent in forums: < 1 sec
Reputation Power: 3

RE: FULLTEXT not working

or in other words, if you are searching for the words "the" and "blue", and if text in your table is in english, than almoust all of the rows will have the word "the", so that word will be ignored (just as you searched for only "blue").

Viewing: Codewalkers Forums > Other Technologies > Database Help > FULLTEXT not working

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump