case statment

[#1]

keyid	test
161289462	valid
50578283	valid
UGM49O3	valid

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

keyid	test
161289462	valid
50578283	valid
UGM49O3	Invalid

Appreciate your help in advance.

Thanks

[#2 · Accepted solution]

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