|Fulltext search [message #654458]
||Wed, 03 August 2016 04:07
Registered: April 2016
Hello, my friends)|
I try to make some search in text.
And I have 2 tables. For example,
First table (CHECK_ALLTEXT T1) it's large table about 60 000 000 rows:
News_1; Some text about wheather
News_2; Some new text about travel and cheap avia tickets
News_3; Text about little rabbits, chickens and porks
News_N Information about cars, trucks, buses
Second table (CHECK_CATEGORY_DIM T2) it's small table about 1 000 rows:
little rabbit; animals
cheap avia; travel
My goal is:
And that's what i do:
from CHECK_ALLTEXT T1, CHECK_CATEGORY_DIM T2
T1.Text LIKE concat('%', T2.Subtext, '%');
However it works only with little tables.
Do you have any decisions of such search?