Databases: searching for a word in entries containing multiple words using 'like'

I think you won't have a choice to use regex. I found this website a long time ago and it saved my life more than once, because I too I find regex complicated: https://regex101.com

You can test you regex, and it can even generate code for you (php, js, java...)

Thanks for the pointer, that looks handy!