What SQL query to search for string containing alphanumeric characters and a specific word


I have a database with tables.

When using phpMyAdmin, I would like to make an SQL query to search in a table (named TEST) the following string :

Where xxx could be any string (of variable length) that could contain alphanumeric characters, hyphen and underscore

Would you know what should be the SQL query ?

Thank you in advance foe any help.


yourcolumn LIKE 'media/%word%.jpg'
This would return anythign that starts with "media/", ends with ".jpg", has the word "word" word somewhere in between those two.