개발관련/DB
MYSQL>FIND_IN_SET
Diademata
2019. 3. 29. 17:47
반응형
한 컬럼의 여러 값을 조회 => Index 값이 나온다.
| name | hobbies |
| Adam | swimming |
| Amy | reading,sports,swimming |
| Carl | filmwatching,writing |
| Carol | reading,swimming |
| Deril | sports |
| Jake | reading,sports,swimming |
| Lola | reading,sports,painting |
| Nina | sports,painting |
| Sam | sports |
select name, FIND_IN_SET('reading', hobbies) as idx from people_hobbies;
| name | idx |
| Adam | 0 |
| Amy | 1 |
| Carl | 0 |
| Carol | 1 |
| Deril | 0 |
| Jake | 1 |
| Lola | 1 |
| Nina | 0 |
| Sam | 0 |
반응형