I've been trying to find a way with MySQL's REGEXP function to return only a portion of a matched row.

I am doing:
SELECT \* FROM table WHERE text REGEXP "[.*]cat[.*]"

The text itself is very long (had to use LONGTEXT field to fit it in the table). So I only want to display

cat

Is there a way I can make it so it only displays the matching text, and not the entire text field?