请教一下 mysql 中如何定义一个为列表的常量啊？

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

推荐学习书目

› Learn Python the Hard Way

Python Sites

› PyPI - Python Package Index

› Pocoo

值得关注的项目

› PyPy

› pyenv

Python 编程

› pep8 Checker

Styles

› PEP 8

This topic created in 2359 days ago, the information mentioned may be changed or developed.

例子:SET @a= ('vehicle','traffic');
select count(*) from 表 WHERE 字段 in @a

这样子写报错了，如何定义一个列表结构的常量呢？

3 replies • 2019-11-11 16:36:14 +08:00

kiracyan

Nov 11, 2019

select 1
union
select 2

binjjam

Nov 11, 2019

set @a='vehicle,traffic';
select count(*) from 表 WHERE FIND_IN_SET(字段,@a);

bmcjxhgwy

Nov 11, 2019

非常感谢，已解决