SQLyog – currently – supports via its GUI the creation and retrieval of table level comments only. By issuing appropriate SQL command you can create and retrieve field level comments as well.
If you select a table in the object browser, then the comments belonging to the fields of the given table will be displayed in the object pane.