如何查询以某些字符开头的内容? [英] How do I query for something that starts with certain characters?

问题描述

这是我的代码:

SELECT SRV_NAME, TOT_CPU, TOT_MEM, SNAP_DATE
FROM capacity.SRV_CAPACITY_SEV
WHERE SRV_NAME in ('absshs1p", "AA03server', 'AA02server', 'BA01server', 'BA03server', 'BC03server') AND SNAP_DATE BETWEEN to_date('10-jun-2012 00:00:00', 'dd-mon-yyyy hh24:mi:ss') AND to_date('12-jun-2012 00:00:00', 'dd-mon-yyyy hh24:mi:ss')
ORDER BY SRV_NAME desc, SNAP_DATE desc;

如何查询以某些字符开头的服务器?例如，我如何为仅以"AA"开头的服务器进行服务搜索?

How would I query for servers that begin with certain characters? For example, how could I serach for servers that only begin with 'AA'?

我正在使用Oracle SQL btw.

I am using Oracle SQL btw.

推荐答案

您可以做到

WHERE SRV_NAME LIKE 'AA%'

这篇关于如何查询以某些字符开头的内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！