Re: use of regex in mysql

On 2/16/2017 2:17 PM, kushal bhattacharya wrote:
> 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
>

First thing you do is normalize your database. Two or three values in one column is not normalized.

Once you properly define your database, the rest is easy.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================