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?