mysql 字段包含某个字符的函数

select * from e_book where types like "%3%";

select * from e_book where find_in_set('3', types);

select * from e_book where locate('3', types);


select * from e_book where INSTR(types,'3');

select * from (
        select
                cb.id, cb.code, cb.contract_type contractType, cb.target,b.real_name targetName,
                cb.start_date startDate, cb.end_date endDate, cb.real_end_date realEndDate, cb.finance_group_id financeGroupId,
                cb.dept_name jobGroupName,
                cb.job_group_id jobGroupId,
                cb.dept_name_en deptNameEn ,
                cb.create_date createDate, cb.creater, cb.status,
                        cb.dept_code,
                        cb.dept_name_en,
                        cb.dept_name,
                        cb.product_line_code,
                        cb.product_line_name,
                        cb.subject_code,
                cb.subject_name,
                    temp.name as tname,
                     case  when locate('劳务',  temp.name) then '1'
            when locate('服务',  temp.name) then '2'
                end as newType
                from cb_contract cb
                left join base b on cb.target = b.id
                        left join contract_template temp on cb.contract_template = temp.id

                where cb.is_delete = 1    
         
            and dept_code in
             (  
                'DEP0009'
             ) 
         
         ) cb

        where 1=1
        and (
         (newType = '2'
         
            and product_line_code in
             (  
                'PL0092'
             ) 
         
         
        )
        or (newType = '2'  and ( product_line_code is null or product_line_code = ''))
        or (newType = '1' )
        )

        order by cb.id desc
        limit 0, 10