Remove all text between 2 sentences in regex

Question

I going crazry with regex.

I need to extract a words between FROM and WHERE in this syntax:

SELECT IDClient, Client FROM Client WHERE IDClient = 1 GROUP BY IDClient, Client ORDER BY IDClient

result = Client

How can I resolve this using regular expressions?

Answer 1

Use a regex cheat sheet, it's not too hard to work out.

Answer 2

/FROM (.*) WHERE/i

Answer 3

(?<=FROM\s+).*(?=\s+WHERE)

That uses a look behind and a lookahead to get what is between FROM and WHERE, and can be modified depending on whether you want the whitespace or not.

Answer 4

You can use this online regular expression builder:

• http://gskinner.com/RegExr/

Or try the tutorials at:

• regular-expressions dot info