Home / Questions / 317940
Accepted
Juan
Asked: 2020-12-24 06:38:46 +0800 CST 2020-12-24 06:38:46 +0800 CST

True or False if a field in a string row has letters (PRESTO)

  • 772

I want to make a query that returns me if for a cell of a string type column in a table, said cell has letters.

Suppose the table is named data and the column is named values ​​.

Ex:

  1. A125636
  2. 15468
  3. 136599
  4. B2566B99

That should return me:

  1. True
  2. False
  3. False
  4. True

I am trying to do this query in Athena (Presto) and it does not work for me, I found that regular expressions can be applied but I do not understand them: https://prestodb.io/docs/current/functions/regexp.html

presto

1 Answers

  1. Best Answer

    I found this solution, if anyone knows another please share it

    SELECT campo1, campo2, regexp_like(campo2, '[a-zA-Z]') 
as validacion from "base de datos"."tabla"
where regexp_like(campo2, '[a-zA-Z]') = true
    • 0