sql语句:
select * from table_name where dbms_lob.instr(column,utl_raw.cast_to_raw('匹配的内容'),1,1)<>0;
e.g:
查询文章内容包含幼儿园的数据
select * from users where dbms_lob.instr(content,utl_raw.cast_to_raw('幼儿园'),1,1)<>0;
sql语句:
select * from table_name where dbms_lob.instr(column,utl_raw.cast_to_raw('匹配的内容'),1,1)<>0;
e.g:
查询文章内容包含幼儿园的数据
select * from users where dbms_lob.instr(content,utl_raw.cast_to_raw('幼儿园'),1,1)<>0;