SELECT sales_teams.sales_agent FROM sales_teams WHERE REGEX(sales_agent, ".* H.*")
The second argument in the
REGEX function is written in the standard Java regular expression format and is case sensitive. In a standard Java regular expression the
. stands as a wildcard for any one character, and the
* means to repeat whatever came before it any number of times. In a
.* regular expression, the Java single wildcard character is repeated, effectively making the
.* regular expression operate the same way as the
* wildcard does elsewhere in SQL.