MyBatisダイナミックsqlでのあいまいなクエリー

1、直接接合%%:

  select * from tab_test where is_deleted = 0
      
          and frame_no like '%${frameNo}%'
      

2、変数を定義する:

  
      select  from tab_test where is_deleted = 0
      
          and frame_no like #{frameNo}
      

3、locate()関数を使う:

    select * from tab_test where is_deleted = 0
    
        and LOCATE(#{frameNo}, frame_no ) > 0
    

4、instr()関数を使用する:

    select * from tab_test where is_deleted = 0
        
            and INSTR(frame_no , #{frameNo})