Wednesday, 15 April 2015

regex - Regular expression in mysql to find w/2 -



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