Simple regular expression question

Question

I'm looking for a regular expression for one of my particular requirement explained below. I believe that this may be very simple & basic for the regex experts.

A regular expression that matches one or more words in a line. Consider this line:

QRYNUMB0007 = SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, EMAIL, CITY, STATE, COUNTRY FROM EMPLOYEE WHERE EMPLOYEEID = ?

In this case, for example, I want to find out whether the words I'm searching/looking for SELECT, FIRSTNAME and EMPLOYEE are available in the same line. Order of occurrence of the words in the line is not important in this case, but all the 3 words should be present in the same line.

Answer 1

If you want to select any one of them

/select|firstname|employee/i

If you want to actually find all of them

/select/i && /firstname/i && /employee/i

And, depending on your language, things can be simpler, eg Python

STRING=mystring.lower()
if "select" in STRING and "firstname" in STRING and "employee" in STRING:
    print "...."