擅长:python、mysql、java
<p>可以执行以下操作以删除sql查询中的方括号:</p>
<pre><code>Select replace(replace(JAnswer,'['),']')
from your table
</code></pre>
<p>您的查询:</p>
<pre><code>SELECT U.iUserSexeType, replace(replace(CA.jAnswer,'['),']') as jAnswer
FROM [User] U
JOIN DBO.ConsultationAnswer CA ON CA.fkiUserId=U.id
LEFT JOIN UserAdresse UA ON UA.fkiUserId=U.id
where fkiConsultationSurveyId=37
and fkiConsultationQuestionId=260
</code></pre>