I wish to have some query like mysql:
select * from api where hostname like ‘thw-dv-lamp-01%’ limit 1;
it failed with:
ERR: error parsing query: found like, expected ; at line 1, char 34
Please shed some light.
Apologize if the question is too newbie.
Thanks a lot in advance