[plug] mysql question

[Shayne O'Neill]

I have a database of job descriptions.

Assuming I have a full text index (according to phpmyadmin) against all
the correct fields, is there anything wrong with;-

SELECT * FROM jobads WHERE
(MATCH(jobtitle,location,paytype,shortdescription,advertisement,contactdetails)
AGAINST ('[search text]')

as a basic search string. it doesnt crash out or anything, but always
comes up empty even when I *know* the search text is in there somewhere.

any gotchyas I need to be lookin out for?

--
"Well, I think if you say you're going to do something and don't do
it, that's trustworthiness."
-- George Bush on CNN online chat, Aug.30, 2000
RIAA Copyright notice trap: http://guild.murdoch.edu.au/~shayne/