Apologies straight off if I've picked the wrong forum - I wasn't sure if it should be here or in the coding section!

Assuming I am in the right place, here's my query...

I'm used to using DB2 and I think the issue here is a difference in SQL between DB2 and MySQL.

Basically, I want to be able to search WITHIN a MySQL field - nothing fancy, just a simple "find this word within this MySQL field". With DB2 I used an INCLUDES clause, but I can't find this for MySQL.

Can anybody assist me with the correct and easiest way to do this?

Many thanks,
David.

Do you ever have one of THOSE days?

Ok, I've realised my error (after much Google'ing) - it was the LIKE clause I used under DB2. And it works perfectly fine under MySQL as well.

So I've sorted it... thanks anyway!

David.

David,

MySQL also has fulltext searching capability. This might be useful for you in future.