Java Regex, replacing keyword in sql query

Question

I'm trying to parse thousands of Oracle SQL script WHERE clauses.

I want to replace the keyword user (as in the person currently logged in) with something else. I can't just do a replace all as user may be used as part of another word in the where clause like a column name, for example, payuser. And I can't simply check is there whitespace on either side of it as it could be inside a bracket or have an equals sign next to it or some other mathematical character.

where (username = user or admin = user) and loggedIn=user order by pay_group_code;

public class TestClass{

     public static void main(String []args){

        String where = "where (username = user or admin = user) and loggedIn=user  order by pay_group_code;";

        where = where.replaceAll("\buser\b", "test");

        System.out.println(where);
     }
}

can you provide a sample input and desired output?

nafas
– nafas

2015-06-05 13:45:42 +00:00
Commented Jun 5, 2015 at 13:45 — nafas
– nafas, Commented Jun 5, 2015 at 13:45

Wiktor Stribiżew · Accepted Answer · 2015-06-05 15:14:01Z

3

Inside a replaceAll, you need to use double escape symbols:

where = where.replaceAll("(?i)\\buser\\b", "test");

Without the double escapes, you match a backspace BS symbol.

See demo

edited Jun 5, 2015 at 15:14

answered Jun 5, 2015 at 13:41

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kev670 Over a year ago

Thanks, I'm also now using (?i) to ignore case so that the regex looks like "(?i)\\buser\\b".

Collectives™ on Stack Overflow

Java Regex, replacing keyword in sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related