MySQL Querible Field Constraint from RegEx

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?

0
source share

Source: https://habr.com/ru/post/919118/


All Articles