sap模糊搜索闪退_SAP HANA 模糊查询(SAP HANA SQL Function Fuzzy search) | 学步园
SAP HANA 模糊查询:具有快速和容错搜索的特征
支持模糊查询的数据类型(列存储):
TEXT
SHORTTEXT
VARCHAR, NVARCHAR
DATE
所有具有 full-text 索引的数据类型。
SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY(0.8))
ORDER BY score DESC;
SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY)
ORDER BY score DESC;
SELECT SCORE() AS score, *
FROM documents
WHERE CONTAINS(doc_content, 'Driethanolamyn', FUZZY(0.8,
'option1=value1, option2=value2'))
ORDER BY score DESC;
post SAP-Garson
原文链接:https://blog.csdn.net/weixin_39752157/article/details/111819980文章来自于网络,如果侵犯了您的权益,请联系站长删除!