문제
입력 코드
SELECT *
FROM Users
WHERE mail REGEXP '^[A-Za-z][A-Za-z0-9_\.\-]*@leetcode(\\?com)?\\.com$'SELECT *
FROM users
WHERE mail REGEXP '^[a-zA-Z][a-zAZ0-9_.-]*@leetcode[.]com$'코드 설명
#SELECT #WHERE #REGEXP
문제 출처
'SQL' 카테고리의 다른 글
| #123. [LeetCode / MySQL] 1327. List the Products Ordered in a Period (0) | 2024.06.23 |
|---|---|
| #122. [LeetCode / MySQL] 1484. Group Sold Products By The Date (0) | 2024.06.22 |
| #121. [LeetCode / MySQL] 176. Second Highest Salary (0) | 2024.06.22 |
| #120. [LeetCode / MySQL] 196. Delete Duplicate Emails (0) | 2024.06.21 |
| #119. [LeetCode / MySQL] 1527. Patients With a Condition (0) | 2024.06.21 |