7.4 Full-text index
SQL
SELECT *
FROM Customers
WHERE CustomerID like '%ANA%'
SPL
| A | |
|---|---|
| 1 | =file(“Customers.ctx”).open() |
| 2 | =A1.index@w(file(“Orders.ctx__IDW”);CustomerID) |
| 3 | =A1.icursor(;like(CustomerID,“*ANA*”);file(“Orders.ctx__IDW”)).fetch() |
| 4 | =A1.close() |
A2 Create full-text index on CustomerID column.
A3 Perform like match query according to index field. Note: If the value being matched is an English word or a number, the match string should contain at least three characters; if the value under match is a Chinese character, there isn’t restriction on the number of characters in the match string.
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProcSPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL
