What is the Java RegEx equivalent for the SQL LIKE clause "% A% B%"?

Question

What is the Java RegEx equivalent for the SQL LIKE clause "% A% B%"?

Pretty simple question, I'm just learning the flavor of Java Regex.

Answer 1

I think this is a sample example: .*A.*B.*

I will edit and add more for specific Java calls.

EDIT # 1:

//simplest match
"".matches( ".*A.*B.*" );

String foo = "";
foo.matches( ".*A.*B.*" );

EDIT # 2: From the API docs :

Pattern p = Pattern.compile(".*A.*B.*");
Matcher m = p.matcher("your-string-here");
boolean b = m.matches();

In addition, I would look at RegexBuddy , its not free, but it has the means to create fragments for many languages, testing and parse regex's, etc.

Answer 2

".? A.? B". . ? , . () " ", * 0 - .

Answer 3

Pattern p = Pattern.compile(".*?A.*?B.*");
Matcher m = p.matcher(str);
if (m.matches()) {
...