728x90
반응형
https://www.w3schools.com/sql/func_mysql_substring_index.asp
MySQL SUBSTRING_INDEX() Function
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
www.w3schools.com
SELECT SUBSTRING_INDEX("www.w3schools.com", ".", 2);
=>www.w3schools728x90
반응형
'DB' 카테고리의 다른 글
| [MySQL] NOW() / CURRENT_TIMESTAMP / SYSDATE() 차이 (0) | 2023.10.19 |
|---|---|
| [Mysql] COUNT(*) COUNT(컬럼) 속도차이 (1) | 2023.10.16 |
| [DB][Mysql] INSTR (0) | 2023.09.30 |
| [DB][Mysql] LEFT, RIGHT (0) | 2023.09.29 |
| [DB][Mysql] SUBSTR (0) | 2023.09.28 |