MySQL Forums
Forum List  »  Full-Text Search

fulltext indexes aren't working with nested queries
Posted by: peerspong pong
Date: August 28, 2012 08:22PM

hi,
whats wrong with my sql?

(this is a pure theoretical nonsense example)

the error that i get is:
Can't find FULLTEXT index matching the column list


SELECT *,
MATCH(myfield) AGAINST('key2') AS test2 /* this doesn't work */
FROM
(
SELECT *,
MATCH(myfield) AGAINST('key1') AS test1 /* this works perfectly */
FROM mytable
)
AS nested1

thank you in advance!



Edited 1 time(s). Last edit at 08/28/2012 08:24PM by peerspong pong.

Options: ReplyQuote


Subject
Views
Written By
Posted
fulltext indexes aren't working with nested queries
4189
August 28, 2012 08:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.