use of regex in mysql

From: kushal bhattacharya <bhattacharya.kushal4_at_gmail.com>
Date: Thu, 16 Feb 2017 11:17:26 -0800 (PST)
Message-ID: <ceb66d14-a455-4b9f-a515-95cb4c6e0cc0_at_googlegroups.com>

[Quoted] suppose i have a row with with coloumn having values-:

sense/thubarhali/temp
sense/humidity
sense/humidity/pressure
sense/pressure

rp12/temp
tap/contain

these are the 6 rows apart from the autoincremented id now i want to fetch those coloumns which contains sense/ but after that i just want to fetch the coloumn having only letter after that so how should i write it on mysql query please suggest me some solution here i am able to fetch coloumn containing sense/ through mysql regex but am not able to do the second task of fetching only those coloumns having only letter after that Received on Thu Feb 16 2017 - 20:17:26 CET