Here is my query
SELECT producer FROM producers WHERE producer REGEXP CONCAT('[[:<:]]', 'dell\'', '[[:>:]]')
I replaced mysql like with this to use word boundary from another example here. But now I am having a problem with escaped apostrophe, it doesn't find the dell' in the database even if there is a match.
So it's the trailing boundary requirement which fails. Which makes sense. Quoting from the docs:
As
'
is not a word character, it cannot be the end of a word, hence[[:>:]]
can't match.