import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class Example {
public static void main(String[] args) {
final String regex = "((?<=[ )()']where)|(?<=[ )()']and)|(?<=[ )()']o[rn])|(?<=[ )()']if)|(?<=[ )()']when)|(?<=having))+(\\s|\\()+[)(,'+_¥£$#\\@\\w\\[\\]\\.\\s]+like\\s*\\(?\\s*(('((\\w|%|'{2})*)')\\s*\\+)*\\s*@p\\d+\\s*(\\+('%'))*\\)";
final String string = "select * from a where #myTable$@_¥£.$@_¥£#columnName like ('%'+@p2+'%')\n"
+ "select * from a where #myTable$_¥£.$_¥£#columnName like ('%'+@p2+'%')\n\n"
+ "(\\w|\\[|\\]|\\.|\\s|'|\\+|\\(|\\)|\\,)\n\n"
+ "select a from b where h like ('%'+@p2+'%')\n"
+ "having b.d like ('%'+@p2)\n"
+ ")join c on a.b like (@p2+'%')\n"
+ " and a.b like (@p2)\n"
+ " if a like ('%abc24''as'+@p2+'%')\n"
+ " case when a like ('%'+@p2+'%') \n"
+ " \n"
+ " where (((a like ('%'+ @p2+'%'))))\n"
+ " where a + 'b' like ('%'+@p2+'%')\n"
+ " where concat(a,b) like ('%'+@p2+'%') or ltrim(a) like ('%'+@p2+'%')\n"
+ "select * from a where concat(a,b) like 'a' and c like d or ltrim(a) like ('%'+@p2+'%')\n"
+ " where isnull(ltrim(a), '0') like ('%'+@p2+'%')\n"
+ " where a + 'b' LIKe ('%'+@p2+'%')\n\n\n"
+ "vICM_EVENTlike roadshowev0like_ where upper(roadshowev0like_.EVENT_NAME) like ('%'+@p1+'%') or upper(roadshowev0like_.EVENT_SYMBOLlike) like ('%'+@p2+'%') and e_.EVENT_SYMBOLike like('%'+@p2+'%')\n\n"
+ "from vICM_INVESTOR investor0_ where (upper(investor0_.OrgId) like ('%'+@p1+'%') or upper(investor0_.Name) like ('%'+@p2+'%')) and investor0_.IsDeactivated=@p3 order by investor0_.Name asc\n\n"
+ " where ((h.g) + upper(concat(investor0_.OrgId, 'd') + (a.d)) like ('%'+@p1+'%') \n\n"
+ " or upper(investor0_.Name) like ('%'+@p2+'%')) and investor0_.IsDeactivated=@p3 order by investor0_.Name asc\n\n"
+ " where (a.b like ('%'+@p2+'%')) and d.g like ('%'+@p2+'%')\n\n\n"
+ "(where a.b like ('%'+@p2)\n\n"
+ " if a like ('%'+@p2)\n"
+ "join a on b.d like ('%'+@p2)\n\n"
+ " // not supported\n"
+ " where a like 'b' and c like ('%'+@p2+'%')\n"
+ " where a like (' '+@p1+'%') \n"
+ "// supported\n"
+ " where a like ('%'+@p1+'%') and c like ('%'+@p2+'%')\n"
+ " \n\n\n";
final Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE);
final Matcher matcher = pattern.matcher(string);
while (matcher.find()) {
System.out.println("Full match: " + matcher.group(0));
for (int i = 1; i <= matcher.groupCount(); i++) {
System.out.println("Group " + i + ": " + matcher.group(i));
}
}
}
}
Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Java, please visit: https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html