擅长:python、mysql、java
<p>有人指出你的字符串格式不正确,我用了这个:</p>
<pre><code>mystr = "prefix 'field1', '', 'field2', 'field3', 'select ... where (column1 = '2017') and ((('literal1', 'literal2', 'literal3', 'literal4', 'literal5', 'literal6', 'literal7') OVERLAPS column2 Or ('literal8') OVERLAPS column3 And" (column4 > 0.0 Or column6 > 0.0)) And column7 IN_COMMUNITY [int1] And column5 = 'literal9') LIMIT 0 ', 'field5', 'field6', 'field7', 'field8', 'field9', '', 'field10'"
found = [a.replace("'", '').replace(',', '') for a in mystr.split(' ') if "'" in a]
</code></pre>
<p>返回:</p>
^{pr2}$