从excel取一列数据，放入sql的in条件筛选时，快速批量修改

打开notepad++

ctrl+H

^    替换为    '
$    替换为    ',

 

select * from table 
where number in
(
'210327131621c0a801dd074931e00000',
'210330094853c0a80acf265284000000',
'210329195504c0a80ace162671e00000',
'210329110828c0a80ad0104371300000',
'210318151841c0a801dd320382a00000',
'210318095127c0a801dc305742a00000',
'210318150312c0a80ace312072a00000',
'210318103043c0a80acf275022a00000',
'210318094709c0a80ace255162a00000',
'210325160032c0a80ad0275291f00000',
'210426161733c0a801dd141911300000',
'210427095141c0a80ace398111900000'
)