yql/essentials/tests/sql/suites/like/like_clause_no_pattern.sql


1
2
3
4
5
6
7
8
9

select
    value,
    case when
    value like "abc"
    then "true"
    else "false"
    end as is_abc
from plato.Input
order by is_abc desc, value asc;