Geek asks and answers

Creating a full-text index in VIEW

Is it possible to create a full text index in VIEW?

If so, given the two columns column1and column2in VIEW, what is SQL to do this?

The reason I would like to do this is because of two very large tables, where I need to search FULLTEXT on one column on each table and combine the results. Results must be ordered as a unit.

Suggestions?

EDIT: It was my attempt to create UNIONand organize on each statement statements.

(SELECT a_name AS name, MATCH(a_name) AGAINST('$keyword') as ascore 
     FROM a WHERE MATCH a_name AGAINST('$keyword'))
UNION  
(SELECT s_name AS name,MATCH(s_name) AGAINST('$keyword') as sscore 
     FROM s WHERE MATCH s_name AGAINST('$keyword'))
ORDER BY (ascore + sscore) ASC

sscore was not recognized.

+3
source share
1 answer

MySQL , . , MySQL , , - , . , 10 , , , .

, SQL script, , ( cronjob a script to) ( , ).

+2

More articles:


All Articles