Display a field using regex I have a table with a field in with data such as:

id | path
1  | /2/9/1 
2  | /2/4/11 
3  | /1/3/11 
4  | /5/3/2 
5  | /2/1/4


I'm wanting to do a select query to show only the first number between the slashes.  Can you use a Regex in the select part of a query?  If so, what is the syntax to find what I need?
You can use SUBSTRING_INDEX() function for that, no need for regexes:

   SUBSTRING_INDEX( SUBSTRING_INDEX(path, '/', 2), '/', -1)