The cate_no value is 6, 2, 9, 13, 19, WHEREcate_noin (6, 7, 8) member & nbsp; a field in the table named cate_no is of the string type. When the cate_no & nbsp; value is & nbsp; 6, 2, 9, 13, 19 & nbsp; (the numerical order is out of order ). SELECT & nbsp; * & nbsp; FROM & nbsp; the value of member & cate_no is 6, 2, 9, 13, 19, WHERE cate_no in (6, 7, 8)
Member table
There is a field called
Cate_no
Is a string type.
When the cate_no value is 6, 2, 9, 13, and 19 (the numerical order is out of order ).
SELECT * FROM member WHERE cate_no in (6, 7, 8)
This data cannot be found,
However
SELECT * FROM member WHERE cate_no in (6)
This data can be searched,
Cate_no in (6, 7, 8)
How to write this MYSQL code?
------ Solution --------------------
SELECT * FROM 'member' WHERE FIND_IN_SET (6, cate_no) OR FIND_IN_SET (7, cate_no) OR FIND_IN_SET (8, cate_no)