Tagged articles

Search SQL

2 articles · Page 1 of 1

Sep 22, 2017 · Databases

Mastering Search SQL: Advanced Full‑Text Queries with CONTAINS, NEAR, and FUZZY

This tutorial demonstrates how to create a table with a Chinese analyzer, insert multilingual records, and leverage Search SQL's CONTAINS, NEAR, and FUZZY operators to perform precise, high‑performance full‑text searches beyond simple LIKE patterns.

CONTAINSChinese AnalyzerFUZZY

0 likes · 9 min read

Mastering Search SQL: Advanced Full‑Text Queries with CONTAINS, NEAR, and FUZZY

StarRing Big Data Open Lab

Sep 15, 2017 · Big Data

Boost Full‑Text Search with Search SQL: Tokenization, CONTAINS, NEAR & FUZZY

This article explains how Search SQL enables easy full‑text search on Transwarp Search by using standard SQL syntax, covering tokenization, analyzer configuration, CONTAINS queries, and advanced NEAR and FUZZY operators to improve performance and query semantics.

FUZZYFull-Text SearchNEAR

0 likes · 9 min read