I'm trying to select strings from my database which doesn't have question marks that's not at the end. For example:
^---should not be selected, since there is a question mark that's not at the end, in the string.
Here is my query:
SELECT response FROM allData WHERE response NOT REGEXP '[?]\\(?!$\\)'
Maybe work for you, try it. :D
SELECT response FROM allData WHERE LOCATE('?', response) = LENGTH(response)