KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a series of tables that contain data I want to full text search. I've tried combining the tables with UNION , but the result loses its fulltext index so can't be fulltext searched. I don't think that putting the data into a temp table is the way to go. Is there someway that I can fulltext search these tables efficiently? Thanks in advance! UPDATE: my query for fulltext was SELECT ID, Title, Description, Author, MATCH (Title,Tags,Body) AGAINST ("search terms") AS Relevance FROM [combination of tables goes here] WHERE MATCH (Title,Tags,Body) AGAINST ("search terms")
Tags (comma-separated)
Save Edits
Cancel