Fulltext search [message #654458] |
Wed, 03 August 2016 04:07 |
|
NikoTrend1
Messages: 4 Registered: April 2016
|
Junior Member |
|
|
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:
Title; Text
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:
Subtext; Category
little rabbit; animals
car; wehicles
....
cheap avia; travel
My goal is:
News_2, travel
News_3, animals
...
News_N, wehicles
And that's what i do:
SELECT T1.Title,
T2.Category
from CHECK_ALLTEXT T1, CHECK_CATEGORY_DIM T2
where
T1.Text LIKE concat('%', T2.Subtext, '%');
However it works only with little tables.
Do you have any decisions of such search?
|
|
|