I must request if there's a potential method to choose all rows from the table in which the content of the column (varchar(255)) could have figures others than standard british (a-zA-Z) or figures from different languages like Greek, French.
For instance when the table consists of the next data:
-- ID, Address -- | 1, "Test1" | | 2, "Tåst2" | | 3, "Test1" |
I must get just the second row (2, "Tåst2")
I attempted to make use of regular expression doing the next:
SELECT * FROM contact_info WHERE address NOT REGEXP '[a-zA-Z]';
But no luck!
Any help could be appreciated!
Match the entire text
SELECT * FROM contact_info WHERE address NOT REGEXP '^[a-zA-Z0-9]*$';