[thelist] *crackle* *buzz* calling Rudy and his magical sql brain

rudy r937 at interlog.com
Sat Feb 1 08:40:01 CST 2003


thanks for the kind words, dunstan, but i've never worked with mysql's
proprietary MATCH AGAINST syntax

you'd probably do better with a more descriptive subject line, too, to
encourage others to read your question

some comments about your query --

you don't need the DISTINCT keyword if you're selecting the primary key from
a single table, and your FROM clause indeed selects from a single table, but
you reference a different table in the LIKE expressions, that you may need
to join to

you didn't say what's wrong with your query -- does it run?  do you get a
syntax error?  does it return anything?  does it return the wrong results?

just a hunch, but maybe you should not mix MATCH AGAINST and LIKE

according to the docs, you could say MATCH (siteurl.url) AGAINST ('web
standards') and it would find either word, which is the same as your two
LIKE expressions

another thing i picked up from the docs is the need for a fulltext index --
have you created that?

rudy




More information about the thelist mailing list