case statment

Praskavi — Wed, 01 Dec 2021 00:11:20 GMT

I am using below query but still getting wrong results.

Select keyid,CASE
WHEN keyid like '^[A-Za-z]*%' THEN 'invalid'
else 'valid'
end as test

from table

I am expecting below

Appreciate your help in advance.

Thanks

Re: case statment

Praskavi — Wed, 01 Dec 2021 02:36:04 GMT

I used CASE WHEN keyid RLIKE '^[A-Za-z]' THEN 'invalid' else 'valid' end as test. This is working !