pycharm 用正则表达式搜索
如果有如下sql语句:
sql = 'select id,name from data_dataset where data_type = {} and deleted = 0'.format(type)
sql = "select task_id, status, dataset_id from task_status where task_id = '{}'".format(task_id)
sql = 'select * from task_status'
sql = "select task_id, status, dataset_id, result from audio_task_status where task_id = '{}'".format(task_id)
sql = "select task_id, status, dataset_id, bakfield1 from task_status where task_id = '{}'".format(task_id)
如果要匹配所有sql,则使用正则查询语句:
select .+ from
匹配效果可以使用正则表达式在线测试进行演示。