Just putting a note as I have spent ages looking for a solution and getting it to work in my environment.
What?
Need to be able to omit HTML tags in certain fields of a mySQL database.
Why? ...
... REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric
FROM
...
Usage
-- Using the ORACLE example
SELECT
Column1,
Column2,
(LENGTH(
TRIM(
TRANSLATE(
:ParameterToCheck,
'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.