regular expression in Mysql Select

[frenchy373]

Hello
I want to do a select in mysql with a regular expression to find a word in a text, case sensitive

for example the texts are :
"Hello, my firstname is bob and my lastname is mylan"
"My cat is white"
"I like cars"

the search word is :
"my"

and my sql select must return me
"Hello, my firstname is bob and my lastname is mylan"

so my select must be like
SELECT TEXT FROM TABLE WHERE TEXT LIKE ........my......

Thank you for your help

[cahva]

SELECT TEXT FROM TABLE WHERE TEXT LIKE BINARY '%my%'