Regular Expressions 101

Pro

as the literal text as (case sensitive)

Group 1(\w+)

\w+any word character, repeated at least once

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

27 tokens

Regular Expression

as (\w+)

New

"Select s.BOOK_ID as bookID,s.first_name as firstName, s.last_name as lastName , b.book_name as bookName , b.price as price  FROM STUDENTS s JOIN BOOKS b ON b.ID = s.BOOK_ID";

Substitution

"Select s.BOOK_ID as bookID,s.first_name as firstName, s.last_name as lastName , b.book_name as bookName , b.price as price  FROM STUDENTS s JOIN BOOKS b ON b.ID = s.BOOK_ID";