I have been trying to remove rows that have non-english words in Postgresql. However, it does not seem working. This is my current code and sample data:
Select
translationid,
medium
from translation
where medium like '%[^A-Z,a-z]%'
Asked
Active
Viewed 155 times
0
Sriram
- 348
- 2
- 13
-
1Those *"English"* characters are in fact Latin – Cid Sep 01 '21 at 13:05
-
how do i extract it in postgresql? – Sriram Sep 01 '21 at 13:05
1 Answers
1
You need a regular expression match with the ~ operator:
WHERE NOT meduim ~ '[^A-Za-z]'
You might want to add other characters like space or - to the list in the brackets.
Laurenz Albe
- 167,868
- 16
- 137
- 184
-
-
If you want to *exclude* all entries with non-english characters, add a `NOT` - I'll update the answer. – Laurenz Albe Sep 01 '21 at 13:48