56,678
社区成员
发帖
与我相关
我的任务
分享
create table test(col varchar(20));
insert into test values('xxaaayy');
insert into test values('567aaA,');
insert into test values('Aaa67676');
insert into test values('123aAaxyz');
insert into test values('testAaA');
insert into test values('AAAtest');
select
*,
substring(col,locate('aaa',col),3) as skey
from
test
where
col like '%aaa%'
/**
col skey
xxaaayy aaa
567aaA, aaA
Aaa67676 Aaa
123aAaxyz aAa
testAaA AaA
AAAtest AAA
**/
select title from a where lower(title)='aaa';
select *,'aaa' as skey from tb where col like '%aaa%'