【Oracle】模糊查询&按匹配度排序

select t.zh_name from psn_ins t where t.ins_id = 857 and t.zh_name like '%' || '肖锐' || '%';

select t.zh_name from psn_ins t where t.ins_id = 857 and t.zh_name like '%' || '肖锐' || '%'
       order by (case when t.zh_name = '肖锐' then 1 
       				  when t.zh_name like '肖锐' || '%' then 2
                      when t.zh_name like '%' || '肖锐' then 3
                      when t.zh_name like '%' || '肖锐' || '%' then 4 
					  else 0 end);