regex - Regular expression in mysql to find w/2 -
i have query below, select rows contain gb:2
, word samsung
there in 3 word.
but info contain gb-2
or gb,3
etc. want alter query gb*
take character , alphabet after gb
.
how can set gb*
in query?
select description mobile content regexp '[[:<:]]gb:2( [^ ]+){0,3} samsung[[:>:]]'
mysql regex
No comments:
Post a Comment