Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql-Mysql中字段本身就是用逗号分隔的，怎么进行IN的筛选

mysql-Mysql中字段本身就是用逗号分隔的，怎么进行IN的筛选

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-06 09:34:09
Original
1027 people have browsed it

mysqlsql数据库

这是我数据库中的数据 图片说明

我像图2中这样写的sql居然能正确的匹配，因为之前没有这么写过，感觉这样写不太正确，但是结果确实是我想要的，请大神帮忙看看这样写对吗图片说明
如果不对的我，我就是想取得图2中结果1中的数据该怎么写呢

Related labels：
mysql sql 数据库
Previous article：二进制-mysql 数据库中 blob 类型存储数字 无法正常插入更新 Next article：.net执行页面提交数据到mysql数据库报错，求指导
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
I would like to ask if PHP can develop green Internet software or scripts?
From 1970-01-01 08:00:00
0
0
0
Does idea git have the > icon that prompts when the file status changes like eclipse, or a similar icon?
From 1970-01-01 08:00:00
0
0
0
Why can't jQuery or DOM methods like getElementById locate elements?
From 1970-01-01 08:00:00
0
0
0
javascript - js and c++ encryption and decryption through des
From 1970-01-01 08:00:00
0
0
0
Questions about gettype and var_dump?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template