Tencent Cloud

Recent Pages

WHERE Syntax

마지막 업데이트 시간:2024-01-20 17:25:15

The WHERE statement is used to extract the logs that meet the specified conditions.
Syntax Format
* | SELECT column (KEY) WHERE column (KEY) operator value
The operator can be =, <>, >, <, >=, <=, BETWEEN, IN, or LIKE.
Note: 
In SQL, search conditions deliver higher performance than filters. You are advised to use search conditions to meet data filtering requirements. For example, you can use status:>400 | select count(*) as logCounts instead of * | select count(*) as logCounts where status>400 to get the statistical result faster.
The WHERE statement does not allow the AS clause. For example, if level:* | select level as log_level where log_level='ERROR' is run, an error will be reported because the statement does not comply with the SQL-92 specifications.
Syntax Example
Query logs with status code greater than 400 in the log data:
* | SELECT * WHERE status > 400
Query the number of logs whose request method is GET and client IP is 192.168.10.101 in the log data:
* | SELECT count(*) as count WHERE method='GET' and remote_addr='192.168.10.101'
Count the average size of requests with the URL suffix of .mp4:
* | SELECT round(sum(body_bytes_sent) / count(body_bytes_sent), 2) AS avg_size  WHERE url like '%.mp4'
﻿

문의하기

고객의 업무에 전용 서비스를 제공해드립니다.

기술 지원

더 많은 도움이 필요하시면, 티켓을 통해 연락 바랍니다. 티켓 서비스는 연중무휴 24시간 제공됩니다.

연중무휴 24시간 전화 지원

tencent cloud

Recent Pages

WHERE Syntax

Syntax Format

Syntax Example

문제 해결에 도움이 되었나요?

문제 해결에 도움이 되었나요?

tencent cloud

가입하기

로그인

Recent Pages

WHERE Syntax

Syntax Format

Syntax Example

문제 해결에 도움이 되었나요?

문제 해결에 도움이 되었나요?