Posted by gosha bine on 06/19/07 09:52

On 19.06.2007 09:08 lawrence k wrote:
> Wierd. Go to this page:
>
> http://www.ihanuman.com/search.php
>
> and search for "yoga"
>
> This query gets run:
>
> SELECT * FROM albums WHERE MATCH(name,description) AGAINST ('yoga')
> ORDER BY id DESC
>
> it returns nothing. (other searches work, but not the one for
> "yoga").
>
> But if I do SELECT * FROM albums WHERE description LIKE '%yoga%'
>
> then I get 5 matches
>
> What the hell??
>

try adding "IN BOOLEAN MODE" to your query:


--
gosha bine

extended php parser ~ http://code.google.com/p/pihipi
blok ~ http://www.tagarga.com/blok

• Next in forum: Re: Setting my own session handler..
• Prev in forum: Re: Setting my own session handler..
• Thread view: Re: why does MATCH/AGAINST fail to catch entries that LIKE does catch?

[Reply to this message]