擅长:python、mysql、java
<p>如果您知道SQL字符串应该是什么样子的话,这里有一个很简单的方法。在</p>
<p>我们匹配SQL字符串,并将其余字符串拆分为起始字符串和结束字符串。在</p>
<p>然后,我们匹配更简单的字段模式,并从start开始为该模式构建一个列表,在SQL匹配中添加,然后从结束字符串添加字段。在</p>
<pre><code>sqlmatch = 'select .* LIMIT 0'
fieldmatch = "'(|\w+)'"
match = re.search(sqlmatch, mystring)
startstring = mystring[:match.start()]
sql = mystring[match.start():match.end()]
endstring = mystring[match.end():]
result = []
for found in re.findall(fieldmatch, startstring):
result.append(found)
result.append(sql)
for found in re.findall(fieldmatch, endstring):
result.append(found)
</code></pre>
<p>结果如下所示:</p>
^{pr2}$