Fuzzy query in oracle with special symbols

author: admin Post: August 28, 2023 62read 0Comment

Fuzzy query in oracle with special symbols
the
It can be queried with the like statement, but it cannot be recognized if there are special symbols, such as: #, %, _, etc.
the
You can use regexp_like (field name, ‘fuzzy words with special symbols’) this query
the
Example: www.2cto.com
the
SELECT *
the
FROM USER_SOURCE T
the
WHERE TO_CHAR(T.US_TIME, 'yyyymmdd') = '20120615'
the
AND REGEXP_LIKE(US_FROM, 'hello#')
the
the
Author monkey~

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/fuzzy-query-in-oracle-with-special-symbols/