SQL: added command to show matches by regex or regular expression

January 29, 2012
By

Noisy data, inconsistent or irrelevant data, and
duplicate data are reported with the SQL command:

WHERE symptom_name IS NULL
OR t.treatment_name = “”
OR t.treatment_name REGEXP
“[[...]|[.'.]|[.,.]|[.~.]|[.*.]|[.#.]|
[.-.]|[.+.]|[.#.]|[.%.]|[.@.]|[.(.]|
[.).]]”)

Leave a Reply

Your email address will not be published. Required fields are marked *

*