[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: different results between FULLTEXT search and LIKE search
From:       Lamp Lists <lamp.lists () yahoo ! com>
Date:       2008-01-30 21:59:18
Message-ID: 971940.56364.qm () web45716 ! mail ! sp1 ! yahoo ! com
[Download RAW message or body]


--- Lamp Lists <lamp.lists@yahoo.com> wrote:

> 
> --- Lamp Lists <lamp.lists@yahoo.com> wrote:
> 
> > hi,
> > I created table "tasks"
> > create table tasks(
> > task_id, int(4) not null primary key, 
> > task text not null, 
> > resolution text not null, 
> > fulltext (task, resolution)
> > )engine=myisam
> > 
> > when I run
> > 
> > seect * from tasks match(task,resolution)
> > against('"certain service"' in boolean mode)
> > 
> > I would get one record and the phrase is in
> > resolution
> > column.
> > 
> > though, when I serach using LIKE
> > select * from tasks where task like '%certain
> > service%' or resolution like '%certain service%'
> > I would get 2 records. one record is the same as
> the
> > one above and the 2nd has the phrase in task
> column.
> > means there are 2 records, but fulltext shows me
> > only
> > one.
> > 
> > what I'm doing wrong?
> > 
> > thanks.
> > 
> > -ll
> > 
> 
> 
> just made 2nd test and got different reault too:
> 
> select * from tasks match(task,resolution)
> against('+certain +service' in boolean mode) 
> result: 232 records
> 
> select * from tasks where (task like '%certain%' and
> task like '%service%') or (resolution like
> '%certain%'
> and resolution like '%service%')
> result: 7 records
> 
> ?!?!!??
> 
> -ll
> 
> 
> 
> 
>      
>
____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now. 
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=lamp.lists@yahoo.com
> 
> 


even worse:
select count(*) from tasks match(task,resolution)
against('certain') 
result: 0
 
select count(*) from tasks where task like '%certain%'
or resolution like '%certain%';
result: 173

?????

-ll


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]