How to create regular expression for java like sql

I want to search using pattern.

String s ="abstract-package-value";

Suppose I want to search for word which has 'value' in 3rd position.

I want a pattern like *-*-value

various-paint-kindness

Here, suppose *-paint-*.

In sql, I can make like %-paint-%

In this particular example, you may simply split the input string on - and then check the third element:

String s = "abstract-package-value";
String[] parts = s.split("-");
if ("value".equals(parts[2])) {
    System.out.println("MATCH");
}

If you want a pattern matching solution, then String#matches with regex is another option:

String s = "abstract-package-value";
if (s.matches(".*-value")) {
    System.out.println("MATCH");
}

You could also use String#endsWith here as well, which would be similar to the matches option given above.

Try this code and use the variations you would like :

import java.util.regex.Matcher; 
import java.util.regex.Pattern; 

public class Main {
    
	public static void main(String args[]) { 
        
        String ss ="abstract-package-value";
        Pattern pattern = Pattern.compile(".*-value"); 
        Matcher mm = pattern.matcher(ss); 
        while (mm.find()) 
            System.out.println("Pattern found from position " + mm.start() +   " to " + (mm.end()-1)); 
    } 
}

Output :

Pattern found from position 0 to 21