Question: what is the difference between the like and regexp operators?
Answer: LIKE matches an entire column. ... REGEXP , on the other hand, looks for matches within column values, and so if the text to be matched existed in the middle of a column value, REGEXP would find it and the row would be returned. This is a very important distinction.