I'm trying to select specific rows from my database by using regexp, but it's not working for some reason. What am I doing wrong, and how do I fix it?
select response from allData where response regexp '\*([a-zA-Z]+ )+\*'
It's suppose to select rows like:
*kicks you *
^---With an extra space after the word, and before the asterisk. But it's not working. How do I fix it?