SQL 列名通配符 [英] SQL Column Name wildcard

问题描述

我有一个包含 30 多个字段的表格，我想快速将选择范围缩小到列名称以Flag"开头的所有字段.

I have a table with 30+ fields and I want to quickly narrow my selection down to all fields where column name start with 'Flag'.

select * Like Flag% from Table1

推荐答案

您需要按照此处的说明构建动态查询:https://stackoverflow.com/a/4797728/9553919

You will want to build a dynamic query as explained here: https://stackoverflow.com/a/4797728/9553919

SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name = 'Foods'
        AND table_schema = 'YourDB'
        AND column_name LIKE 'Vegetable%'

这篇关于SQL 列名通配符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！