POSITION checks for the location of a specified substring in a string value.
By itself, it’s not a very useful expression, but it is powerful when combined
with the string functions (introduced later in this section). For now, here is
a query that returns the number of characters up to and including the space for
the first name of each of the sales agents:
SELECT sales_agent, POSITION(" " in sales_agent) FROM sales_teams
The first several rows of the results table would look like this:
An introduction to the