[답]
1. MySQL 쿼리 (추천 방식)
SELECT DISTINCT
LEFT(url, LENGTH(url) - LOCATE('/', REVERSE(url))) AS directory
FROM A;
2. 가독성이 좋은 쿼리 (MySQL 8.0 이상)
SELECT DISTINCT
REGEXP_REPLACE(url, '/[^/]+$', '') AS directory
FROM A;
[질문]
아래는 A테이블 url 컬럼입니다.
중복된는 디렉토리 제외하고 출력하는 mysql 쿼리 만들어 주세요.
alpha/vod/son/2022/theory/03/00.mp4
alpha/vod/son/2022/theory/03/01.mp4
alpha/vod/son/2022/theory/03/02.mp4
alpha/vod/son/2022/theory/03/03.mp4
alpha/vod/son/2022/theory/03/04.mp4
alpha/vod/son/2022/theory/03/05.mp4
alpha/vod/son/2022/theory/03/06.mp4
alpha/vod/son/2022/theory/03/07.mp4
alpha/vod/son/2022/theory/03/08.mp4
alpha/vod/son/2022/theory/03/09.mp4
alpha/vod/son/2022/theory/03/10.mp4
alpha/vod/son/2022/theory/03/11.mp4
alpha/vod/son/2022/theory/03/12.mp4
alpha/vod/son/2022/theory/03/13.mp4
alpha/vod/son/2022/theory/03/14.mp4
alpha/vod/son/2022/theory/03/15.mp4
alpha/vod/son/2022/theory/03/16.mp4
alpha/vod/son/2022/theory/03/17.mp4
alpha/vod/son/2022/theory/03/18.mp4
alpha/vod/son/2022/theory/03/19.mp4
alpha/vod/son/2022/theory/03/20.mp4
alpha/vod/son/2022/theory/03/21.mp4
alpha/vod/son/2022/theory/03/22.mp4
alpha/vod/son/2022/theory/03/23.mp4
alpha/vod/son/2022/theory/03/24.mp4
alpha/vod/son/2022/theory/03/25.mp4
alpha/vod/son/2022/theory/03/26.mp4
alpha/vod/son/2022/theory/03/27.mp4
alpha/vod/son/2022/theory/03/28.mp4
alpha/vod/son/2022/theory/03/29.mp4
alpha/vod/son/2022/theory/03/30.mp4
alpha/vod/son/2022/theory/03/31.mp4
alpha/vod/son/2022/theory/03/ques/01.mp4
alpha/vod/son/2022/theory/03/ques/02.mp4
alpha/vod/son/2022/theory/03/ques/03.mp4
alpha/vod/son/2022/theory/03/ques/04.mp4
alpha/vod/son/2022/theory/03/ques/05.mp4
alpha/vod/son/2022/theory/03/ques/06.mp4
alpha/vod/son/2022/theory/03/ques/07.mp4
alpha/vod/son/2022/theory/03/ques/08.mp4
alpha/vod/son/2022/theory/03/ques/09.mp4
alpha/vod/son/2022/theory/03/exam/01.mp4
alpha/vod/son/2022/theory/03/exam/02.mp4
alpha/vod/son/2022/theory/03/exam/03.mp4
alpha/vod/son/2022/theory/03/exam/04.mp4
alpha/vod/son/2022/theory/03/exam/05.mp4
alpha/vod/son/exams/2023/theory/yblee/10028/01.mp4
alpha/vod/son/2021/theory/01/01.mp4
alpha/vod/son/2021/theory/01/02.mp4
alpha/vod/son/2021/theory/01/03.mp4
alpha/vod/son/2021/theory/01/04.mp4
alpha/vod/son/2021/theory/01/05.mp4
alpha/vod/son/2021/theory/01/06.mp4
alpha/vod/son/2021/theory/01/07.mp4
alpha/vod/son/2021/theory/01/08.mp4
alpha/vod/son/2021/theory/01/09.mp4
alpha/vod/son/2021/theory/01/10.mp4
alpha/vod/son/2021/theory/01/11.mp4
alpha/vod/son/2021/theory/01/12.mp4
alpha/vod/son/2021/theory/01/13.mp4
alpha/vod/son/2021/theory/01/14.mp4
alpha/vod/son/2021/theory/01/15.mp4
alpha/vod/son/2021/theory/01/16.mp4
alpha/vod/son/2021/theory/01/17.mp4
alpha/vod/son/2021/theory/01/18.mp4
alpha/vod/son/2021/theory/01/19.mp4
alpha/vod/son/2021/theory/01/20.mp4
alpha/vod/son/2021/theory/01/21.mp4
alpha/vod/son/2021/theory/01/22.mp4
alpha/vod/son/exams/2021_07_01.mp4
alpha/vod/son/exams/2022_08_01.mp4
alpha/vod/son/exams/2023/theory/hsgang/10030/01.mp4
alpha/vod/son/exams/2023/theory/hsgang/10030/02.mp4
alpha/vod/son/2024/blackbox/0101/01.mp4
alpha/vod/son/2024/blackbox/0101/02.mp4
alpha/vod/son/exams/2024/theory/hsgang/10030/202401.mp4
alpha/vod/son/exams/2024/theory/hsgang/10030/202402.mp4
alpha/vod/son/blackbox/20250404/10030/01.mp4
alpha/vod/son/blackbox/20250404/10030/02.mp4
alpha/vod/son/exams/2025/theory/hsgang/10030/202501.mp4
alpha/vod/son/exams/2025/theory/hsgang/10030/202502.mp4
alpha/vod/son/2022/theory/02/000.mp4
alpha/vod/son/2022/theory/02/001.mp4
alpha/vod/son/2022/theory/02/002.mp4
alpha/vod/son/2022/theory/02/003.mp4
alpha/vod/son/2022/theory/02/004.mp4
alpha/vod/son/2022/theory/02/005.mp4
alpha/vod/son/2022/theory/02/006.mp4
alpha/vod/son/2022/theory/02/007.mp4
alpha/vod/son/2022/theory/02/008.mp4
alpha/vod/son/2022/theory/02/009.mp4
alpha/vod/son/2022/theory/02/010.mp4
alpha/vod/son/2022/theory/02/011.mp4
alpha/vod/son/2022/theory/02/012.mp4
alpha/vod/son/2022/theory/02/013.mp4
alpha/vod/son/2022/theory/02/014.mp4
alpha/vod/son/2022/theory/02/015.mp4
alpha/vod/son/2022/theory/02/016.mp4
alpha/vod/son/2022/theory/02/017.mp4
alpha/vod/son/2022/theory/02/018.mp4
alpha/vod/son/2022/theory/02/019.mp4
alpha/vod/son/2022/theory/02/020.mp4
alpha/vod/son/2022/theory/02/021.mp4
alpha/vod/son/2022/theory/02/022.mp4
alpha/vod/son/2022/theory/02/023.mp4
alpha/vod/son/2022/theory/02/024.mp4
alpha/vod/son/exams/2023/theory/jglee/10039/01.mp4
alpha/vod/son/2024/blackbox/0102/01.mp4
alpha/vod/son/2024/blackbox/0102/02.mp4
alpha/vod/son/exams/2024/theory/jglee/01.mp4
alpha/vod/son/exams/2024/theory/jglee/02.mp4
alpha/vod/son/blackbox/20250404/10039/01.mp4
alpha/vod/son/blackbox/20250404/10039/02.mp4
alpha/vod/son/exams/2025/theory/jglee/10039/202501.mp4
alpha/vod/son/exams/2025/theory/jglee/10039/202502.mp4
alpha/vod/son/2024/theory/03/001.mp4
alpha/vod/son/2024/theory/03/002.mp4
alpha/vod/son/2024/theory/03/003.mp4
alpha/vod/son/2024/theory/03/004.mp4
alpha/vod/son/2024/theory/03/005.mp4
alpha/vod/son/2024/theory/03/006.mp4
alpha/vod/son/2024/theory/03/007.mp4
alpha/vod/son/2024/theory/03/008.mp4
alpha/vod/son/2024/theory/03/009.mp4
alpha/vod/son/2024/theory/03/010.mp4
alpha/vod/son/2024/theory/03/011.mp4
alpha/vod/son/2024/theory/03/012.mp4
alpha/vod/son/2024/theory/03/013.mp4
alpha/vod/son/2024/theory/03/014.mp4
alpha/vod/son/2024/theory/03/015.mp4
alpha/vod/son/2024/theory/03/016.mp4
alpha/vod/son/2024/theory/03/017.mp4
alpha/vod/son/2024/theory/03/018.mp4
alpha/vod/son/2024/theory/03/019.mp4
alpha/vod/son/2024/theory/03/020.mp4
alpha/vod/son/2024/theory/03/021.mp4
alpha/vod/son/2024/theory/03/022.mp4
alpha/vod/son/2024/theory/03/023.mp4
alpha/vod/son/2024/theory/03/024.mp4
alpha/vod/son/2024/theory/03/025.mp4
alpha/vod/son/2024/theory/03/026.mp4
alpha/vod/son/2024/theory/03/027.mp4
alpha/vod/son/2024/theory/03/028.mp4
alpha/vod/son/2024/theory/03/029.mp4
alpha/vod/son/2024/theory/03/030.mp4
alpha/vod/son/2024/theory/03/031.mp4
alpha/vod/son/2024/theory/03/032.mp4
alpha/vod/son/2024/theory/03/033.mp4
alpha/vod/son/2024/theory/03/034.mp4
alpha/vod/son/2024/theory/03/035.mp4
alpha/vod/son/2024/theory/03/036.mp4
alpha/vod/son/2024/theory/03/037.mp4
alpha/vod/son/2024/theory/03/038.mp4
alpha/vod/son/2024/theory/03/039.mp4
alpha/vod/son/2024/theory/03/040.mp4
alpha/vod/son/2024/theory/03/041.mp4
alpha/vod/son/2024/theory/03/042.mp4
alpha/vod/son/2024/theory/03/043.mp4
alpha/vod/son/2024/theory/03/044.mp4
alpha/vod/son/2024/theory/03/045.mp4
alpha/vod/son/2024/theory/03/046.mp4
alpha/vod/son/2024/theory/03/047.mp4
alpha/vod/son/2024/theory/03/048.mp4
alpha/vod/son/2024/theory/03/049.mp4
alpha/vod/son/2024/theory/03/050.mp4
alpha/vod/son/2024/theory/03/051.mp4
alpha/vod/son/2024/theory/03/052.mp4
alpha/vod/son/2024/theory/03/053.mp4
alpha/vod/son/2024/theory/03/054.mp4
alpha/vod/son/2024/theory/03/055.mp4
alpha/vod/son/2022/theory/03/exam/01.mp4
alpha/vod/son/2022/theory/03/exam/02.mp4
alpha/vod/son/2022/theory/03/exam/03.mp4
alpha/vod/son/2022/theory/03/exam/04.mp4
alpha/vod/son/2022/theory/03/exam/05.mp4
alpha/vod/son/exams/2023/theory/yblee/10028/01.mp4
alpha/vod/son/2024/blackbox/0103/01.mp4
alpha/vod/son/2024/blackbox/0103/02.mp4
alpha/vod/son/exams/2024/theory/yblee/10045/202401.mp4
alpha/vod/son/blackbox/20250404/10045/01.mp4
alpha/vod/son/blackbox/20250404/10045/02.mp4
alpha/vod/son/exams/2025/theory/yblee/10045/202501.mp4
alpha/vod/son/2025/02/01/001.mp4
alpha/vod/son/2025/02/01/002.mp4
alpha/vod/son/2025/02/01/003.mp4
alpha/vod/son/2025/02/01/004.mp4
alpha/vod/son/2025/02/01/005.mp4
alpha/vod/son/2025/02/01/006.mp4
alpha/vod/son/2025/02/01/007.mp4
alpha/vod/son/2025/02/01/008.mp4
alpha/vod/son/2025/02/01/009.mp4
alpha/vod/son/2025/02/01/010.mp4
alpha/vod/son/2025/02/01/011.mp4
alpha/vod/son/2025/02/01/012.mp4
alpha/vod/son/2025/02/01/013.mp4
alpha/vod/son/2025/02/01/014.mp4
alpha/vod/son/2025/02/01/015.mp4
alpha/vod/son/2025/02/01/016.mp4
alpha/vod/son/2025/02/01/017.mp4
alpha/vod/son/2025/02/01/018.mp4
alpha/vod/son/2025/02/01/019.mp4
alpha/vod/son/2025/02/01/020.mp4
alpha/vod/son/2025/02/01/021.mp4
alpha/vod/son/2025/02/01/022.mp4
alpha/vod/son/2025/02/01/023.mp4
alpha/vod/son/2025/02/01/024.mp4
alpha/vod/son/2025/02/01/025.mp4
alpha/vod/son/2025/02/01/026.mp4
alpha/vod/son/2025/02/01/027.mp4
alpha/vod/son/2025/02/01/028.mp4
alpha/vod/son/2025/02/01/029.mp4
alpha/vod/son/2025/02/01/030.mp4
alpha/vod/son/2025/02/01/031.mp4
alpha/vod/son/2025/02/01/032.mp4
alpha/vod/son/2025/02/01/033.mp4
alpha/vod/son/2025/02/01/034.mp4
alpha/vod/son/2025/02/01/035.mp4
alpha/vod/son/2025/02/01/036.mp4
alpha/vod/son/2025/02/01/037.mp4
alpha/vod/son/2025/02/01/038.mp4
alpha/vod/son/2025/02/01/039.mp4
alpha/vod/son/2025/02/01/040.mp4
alpha/vod/son/2025/02/01/041.mp4