擅长:python、mysql、java
<p>您可以使用正则表达式来替换这些。正则表达式捕获单引号内的值(如果后跟空格和等号),然后仅用值替换引号和值</p>
<pre class="lang-py prettyprint-override"><code>import re
query = '''UPDATE table1 SET 'variable1' = 'value1', 'something' = "['bla', 'yada']", location = 'chicago' WHERE id = 9'''
updated_query = re.sub(r"'([^']+)'(?=\s=)", r"\1", query)
print(query)
print(updated_query)
</code></pre>
<p><strong>输出</strong></p>
<pre class="lang-none prettyprint-override"><code>UPDATE table1 SET 'variable1' = 'value1', 'something' = "['bla', 'yada']", location = 'chicago' WHERE id = 9
UPDATE table1 SET variable1 = 'value1', something = "['bla', 'yada']", location = 'chicago' WHERE id = 9
</code></pre>