Altering a Table with a where clause

[Manat]

Hello all

I need to update my catalog table. Can anyone give me an SQL script that does this:

I have a field called child. And many different products.
I have a field called productName. So, I would first apply a %Like clause, Because the entries in the productName field mostly consists of 3 or 4 words.

So where productName has the word xdocs in it, update the child field and put the number 3 in it.

Can someone show me how I would do this in SQL?
I'll be doing this in PhpMyAdmin.

Before I try anything, would this work?

UPDATE tablename SET child = 1 WHERE productName LIKE %xdocs%

Would the above work? Any quotation marks needed anywhere?
Thanks

[Manat]

Thanks everyone
It tried it, it worked.