如何在mysql中进行查询而不将所有插入放在引号中(我有一个很大的单子,要引用和取消引用每个单词需要很多时间)例子:
SELECT * FROM names WHERE names.first IN ("joe", "tom", "vincent")
drnojrws1#
既然您说过列表是逗号分隔的,那么只需使用“查找并替换”功能查找所有逗号并将其替换为 "," 结果应该是 joe","tom","vincent"," 你可以简单的复制到mysql中。然后您所要做的就是编辑字符串的开始和结束
","
joe","tom","vincent","
1条答案
按热度按时间drnojrws1#
既然您说过列表是逗号分隔的,那么只需使用“查找并替换”功能查找所有逗号并将其替换为
","
结果应该是joe","tom","vincent","
你可以简单的复制到mysql中。然后您所要做的就是编辑字符串的开始和结束