FIND_IN_SET 사용법 > MySQL

STUDY ROOM

MySQL

FIND_IN_SET 사용법

페이지 정보

작성자 JMStudy 작성일08-06-09 21:25 조회8,210회 댓글0건

본문

SELECT * FROM set_test WHERE FIND_IN_SET('Sports',myset) > 0;

+-------+-----------------------+---------+
| rowid | myset | myset+0 |
+-------+-----------------------+---------+
| 1 | Sports | 2 |
| 2 | Travel,Sports | 3 |
| 3 | Travel,Dancing | 5 |
| 4 | Travel,Sports | 3 |
| 5 | Travel,Sports,Dancing | 7 |
| 6 | Travel,Dancing | 5 |
| 7 | Sports | 2 |
| 8 | Travel,Dancing | 5 |
+-------+-----------------------+---------+
댓글목록

등록된 댓글이 없습니다.