How to check in MySQL if a string is solely made up of the letters of the English alphabet?

Question

Consider the following minimal example.

CREATE TABLE Student (
  Name varchar(50),
  CHECK (isEnglish(Name))
)

I want to add a constraint that the name is in the English alphabet (a-z, A-Z) while inserting a new tuple in the STUDENT table. How do I do this? That is, what should I put in place of isEnglish(Name)?

Does this answer your question? [Is it Possible to Enforce Data Checking in MySQL using Regular expression](https://stackoverflow.com/questions/16005283/is-it-possible-to-enforce-data-checking-in-mysql-using-regular-expression) — Tobias S., Oct 23 '21 at 14:25

rosh-dev851 · Accepted Answer · 2021-10-24T02:33:26.350

4

Hope this helps but only works on MySQL 8.0

CREATE TABLE Student (
  Name varchar(50) CHECK (Name REGEXP '^[A-Za-z]+$')
)

edited Oct 24 '21 at 02:33

answered Oct 23 '21 at 16:17

rosh-dev851

534
4
8

How to check in MySQL if a string is solely made up of the letters of the English alphabet?

1 Answers1