[RESOLVED] Searching by string which is contained by a string

[itaym02]

Greetings.

this is my table:

names

itay
moay
bobo
mixo

How do I read only the records that have 'ay' in them.

I work with MySql 4.0

Thanks
I M

[thorpe]

SELECT names FROM tbl WHERE names LIKE '%ay%';

[itaym02]

Thanks

Itay