Sorry, I didn't explain properly.

I want the opposite of that.

I need this string "myzoos" to match the database entry "zoos", not the other way round as I must have suggested.

I'm using ci so upper is irrelevant.

Imagine I need to use a wildcard on the actual database entries:)

Thanks:)

SELECT FROM dictionary where word LIKE '%myzoo'

will throw up things like mamyzoo, dobdomyzoo ect,. but not just "zoo"