select *, a.pc_on_rank from (select * , RANK() OVER(ORDER BY ranking asc) as pc_on_rank from a_rank where online = '실시간 스트리밍 중' and type = 'pc' and gettime = '1651485886' ) a where ( name like '%야옹%' or name like '%야옹' or name like '야옹%' or name = '야옹' )