Possible to use regex column specification with WHERE clause?

[Ryabin, Thomas]

Hi,

 

I know that it is possible to use regex column specification with the
SELECT clause like so:

SELECT `employee.*` FROM employees;

 

I was wondering if it is possible to use it with the WHERE clause also.
For example I want to create the query:

SELECT `employee.*` FROM employees WHERE $1 = 'Steve';

 

where $1 represents a column that was matched by the regex. Any ideas?

 

Thanks,

Thomas Ryabin