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