Hi there, I am trying fulltext to speed up my queries; but what would the query line be, when I would like to match the phrase: "This is a text"?
With a like query i would do "WHERE column LIKE '%This Is a text%';" I've tried "MATCH column AGAINST("'+this +is +a +test'");" but this returns, all records which have "this" "is" etc. but not the phrase. Thanks for the advice, Jeroen --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php