|
|
Posted by Alexander Kuznetsov on 10/08/58 11:28
if you are 100% sure you cannot sue full text search,
do it yourself:
for instanse, for row
ID Make Model
1 Toyota Camry
add these row to an additional table (ID, TOKEN)
1 TOYOTA
1 OYOTA
1 YOTA
1 OTA
1 TA
1 A
1 CAMRY
1 AMRY
1 MRY
1 RY
1 Y
etc.
that done, instead of MODEL LIKE '%OYO%' or MAKE LIKE '%OYO%' you can
use
TOKEN LIKE 'OYO%' which is sargeable
Maintaining tokens is another story, long and boring
Navigation:
[Reply to this message]
|