[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