--数字类型
select * from [表名] where cast([字段名] as char) like '%1%'
select * from newploay where cast(no2 as char) like '%1%'
--时间类型
select * from [表名] where (TO_CHAR([字段名], 'yyyy-mm-dd hh24:mi:ss') LIKE '%2021%')
select * from newploay where (TO_CHAR(no3, 'yyyy-mm-dd hh24:mi:ss') LIKE '%2021%')