DISQUS

Lawrence · 9 months ago

Thank you
////AE · 5 months ago

Is there a way to use regexp when defining a table to SELECT $something from?
santoshb · 1 month ago

may i know Why this query showing false result

select "hellooo" REGEXP "^h[el]+o$";
Shane · 6 days ago

santoshb,

i don't know if you have the answer to your question yet, but your regexp is only look for one 'o'. The $ sign means the absolute end of the string.

You could either do:

^h[el]+o

or..

^h[el]+ooo$