Sorry for asking what should be a fairly simple question.

Say I have the search term "myzoo" and a database entry "zoo" how would I go about getting it to match?

Or in other terms, how can I get mysql to match the last part of a search term.


thanks very much guys, I'm incredibly stuck with this.