Find Value

[Mission Impossible]

Hello

I want find value in column, i use this code but return 0 values:


SELECT * FROM post WHERE mail LIKE '%as%'

I have the link, for example:


www.my.google.com

And want change the value "my" to "your"

Something wrong?

Edit: SOLVED

[james438]

Please post your solution so that others in a similar situation can be helped as well.