Home > database >  MYSQL regular how to match the English word and and Spaces.
MYSQL regular how to match the English word and and Spaces.

Time:12-10


Need to match the document is a sentence, the regular matching as follows, I wrote it. * [: blank:] represents a word and a space, this method can be used to, but I more behind the Numbers, there will be a regular matching timeout (this how to solve), in python can be used to match the word \ w, mysql, please have to match the words in the regular expression, there are alternative. * on behalf of any word method,
 
The SELECT sents
The FROM acad_1990
WHERE the prototype
The REGEXP 'love [: blank:] (. * [: blank:]) {0, 2} always
  • Related