반응형
한 컬럼의 여러 값을 조회 => 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 |
반응형
'개발관련 > DB' 카테고리의 다른 글
| Non clustered Index, clustered Index (0) | 2022.12.20 |
|---|---|
| MYSQL>집계함수 곱연산 (0) | 2019.03.26 |
| MYSQL>Explain (0) | 2019.03.26 |
| MSSQL>페이징 처리 (0) | 2017.07.04 |