“显示数据库"有条件 [英] "Show databases" with condition

问题描述

我想查询一个MySql数据库，以根据提供的条件(应用于数据库名称的条件)向我显示所有现有数据库. 现在，由于我的条件很复杂，简单的"LIKE"条件还不够，我需要使用常规的WHERE子句.

i would like to query a MySql Database to show me all the existing databases based on provided condition (condition applied on the database name). now since my condition is complex, the simple "LIKE" condition is not enough, and i need to use the regular WHERE clause.

任何人都可以提供有关该方法的示例吗?

can anyone provide a sample of how to do that?

推荐答案

USE INFORMATION_SCHEMA;
SELECT `SCHEMA_NAME` from `SCHEMATA` WHERE `SCHEMA_NAME` LIKE "%whatever%";

在文档中了解更多信息..

Read more in the docs.

这篇关于“显示数据库"有条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！