高手 问一下
如
String str = "select id,name,mobile from (select * from a where name in ";
str += "(select name from names order by id) order by name)";
但是 from[大小写不确定可能会是 FROM、From、FRom、FROm、等 order by 也一样]
请问想得到 下面的结果:
"from (select * from a where name in ";
"(select name from names order by id) ";
正则表达式怎么写
如
String str = "select id,name,mobile from (select * from a where name in ";
str += "(select name from names order by id) order by name)";
但是 from[大小写不确定可能会是 FROM、From、FRom、FROm、等 order by 也一样]
请问想得到 下面的结果:
"from (select * from a where name in ";
"(select name from names order by id) ";
正则表达式怎么写
是想通过正则表达式匹配
"from (select * from a where name in "; 或"(select name from names order by id) ";
吗?
然后处理成什么呢?
一般只听说用来判断是不是匹配而已不过楼主的需求可以用
String的toLowerCase()解决