SQL query required

Hi

Can someone write a small sql-query for me?

After transferring the profiles from 6.1 to 7.0 the "sex"field wasn't transferred properly.

Now I have about 400 profiles with no data in that field.

And that makes a search difficult.

I need a sqlquery for phpmyadmin:

If in the table "profiles" the field "sex" is empty, then add the text "male" into the field.

Does someone have a query for that please?

Thanks in advance!

Update `Profiles` SET `Sex`='male' WHERE `Sex` = '';