Programming

select filed1,field2,field3 
from database 
where (field1 contains only alphanumeric chars and NOT only numbers)

21test ==> OK
test ==> OK
test21 ==> OK
te21st ==> OK
12345 ==> Exclude it

where REGEXP_LIKE (field1,'^[a-zA-Z]*$')

"^.*[A-Za-z].*$"

"^[[:alnum:]]*[A-Za-z][[:alnum:]]*$"

echo "121221qdsdwd dejcw23132c" | awk '{if($1 ~ /^[[:digit:]]*$/){next} else {print $0}}'

121221qdsdwd dejcw23132c

REGEXP_LIKE (field1,^[[:alnum:]]*[A-Za-z][[:alnum:]]*$)

REGEXP_LIKE (field1,^[[:alnum:]]*[A-Za-z][[:alnum:]]*$)

NOT REGEXP_LIKE (field1,^[[:digit:]]*$)