1
inmyfree 2016-01-21 17:46:14 +08:00
select * from table_a where xx like "%xxxx%" or xx1 like "%xxx%"
select * from table_b where xx2 like "%xxxx%" or xx3 like "%xxx%" ..... . . . 逃.... |
2
dong3580 2016-01-21 17:47:15 +08:00 via Android
Solr
|
3
fredcc 2016-01-21 18:12:03 +08:00 via Android
elasticsearch
|
4
CheungKe 2016-01-21 18:23:14 +08:00
直接 es , mysql 好像不自带全文检索功能
|
5
qgy18 2016-01-21 20:44:32 +08:00
elasticsearch 够简单。
https://imququ.com/post/elasticsearch.html |
7
lyz1990 2016-01-22 12:35:23 +08:00
ElasticSerach + ik 中文分词,业务数据如果在 mysql 又不想动的话,可以用 go-elasticsearch 同步进去
|
8
ljdawn 2016-01-22 13:03:59 +08:00
mysql Myisam 可以用全文索引..但是还是建议用 es
|