Posted by Jerry Stuckle on 06/19/07 10:09

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 asking MySQL questions in a MySQL newsgroup - such as
comp.databases.mysql. That's where the MySQL experts hang out.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Rich text online editor
• Prev in forum: Re: include("/main.php") won't work on a hosting machine
• Thread view: Re: why does MATCH/AGAINST fail to catch entries that LIKE does catch?

[Reply to this message]