In addition to the VARCHAR(255)
data type VARCHAR(255)
, I would like to add a constraint to the data in the regular expression, for example. [a-zA-Z ]
.
I would like to be able to request a regular expression, for example, how can I request metadata in information_schema
.
I saw some related posts, but not quite what I'm looking for. I saw: Limit varchar () columns to specific values that show how to use constants, and I saw through triggers here: Is it possible to force data validation in MySQL using a regular expression
Can RegExs be used as constraints, and are these constraints being requested? If so, how?
source share