在MySQL查询中使用Like和Concat
|
我正在将文本文件加载到数据库中，并尝试在列出组织名称的表与保存文本文件和与这些组织的潜在匹配的表之间进行快速匹配。
我使用
LOAD INFILE CONCURRENT
occupationoraffiliation
UPDATE raw_faca JOIN orgs AS o
ON raw_faca.org_id IS NULL AND raw_faca.occupationoraffiliation LIKE CONCAT(\'%\',o.org_name,\'%\')
SET raw_faca.org_id = o.org_id;
CONCAT
UPDATE raw_faca JOIN orgs AS o
ON raw_faca.org_id IS NULL AND raw_faca.occupationoraffiliation LIKE (\'%\' + o.org_name + \'%\')
SET raw_faca.org_id = o.org_id;
raw_faca
Match . . . Against
UPDATE raw_faca JOIN orgs AS o ON raw_faca.org_id IS NULL AND MATCH(raw_faca.occupationoraffiliation) AGAINST (o.org_name IN NATURAL LANGUAGE MODE)
SET raw_faca.org_id = o.org_id;
incorrect arguments to AGAINST
没有找到相关结果
已邀请:
1 个回复
屉杆绊
子句将无法利用任何索引。