<p>I am trying to extract a certain part of a column that is between delimiters.</p>

<p>e.g. find foo in the following</p>

<p>test 'esf :foo: bar</p>

<p>So in the above I'd want to return foo, but all the regexp functions only return true|false,
is there a way to do this in MySQL</p>

A combination of
LOCATE
and
MID
would probably do the trick.
If the value
"test 'esf :foo: bar"
was in the field
fooField
:
```
```
MID( fooField, LOCATE('foo', fooField), 3);
```
```