https://leetcode.com/problems/invalid-tweets/description/
Invalid Tweets - LeetCode
Can you solve this real interview question? Invalid Tweets - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
|
1
2
3
4
|
# Write your MySQL query statement below
select tweet_id
from Tweets
where CHARACTER_LENGTH(content)>15
|
cs |
문자열의 길이 관련 문제네요
LENGTH 함수는 Byte를 기준으로 세기때문에 사용하면 좀 곤란하고
CHARACTER_LENGTH 함수를 사용하시면 됩니다.
The problem is with the length of the string.
Since the LENGTH function counts on the basis of bytes, it is a bit difficult to use.
You can use the CHARACTER_LENGTH function.
반응형
'SQL' 카테고리의 다른 글
| leetcode 2356. Number of Unique Subjects Taught by Each Teacher (0) | 2023.04.06 |
|---|---|
| leetcode 1378. Replace Employee ID With The Unique Identifier (0) | 2023.04.06 |
| leetcode 1393. Capital Gain/Loss (0) | 2023.01.26 |
| hackerrank Occupations (0) | 2022.11.13 |
| leetcode 1050. Actors and Directors Who Cooperated At Least Three Times (0) | 2022.07.26 |
댓글