Song Name checks against Japanese, transliterated, or translated names. % is the wildcard, so a search for %love% will find songs that used love or words that translated to love.

Credits: Probably quicker to show a few examples than try to explain it in full. != is the way to express "not".
[Artist=Minimoni]
[Artist=%Musume%] and [Artist!=Coconuts Musume]
[Vocals=Tsuji Nozomi] and [Lyrics!=Tsunku]

Release Date: Use YYYY-MM-DD date format.

Song Types: It's inclusive. Even if you have A-sides unchecked, if you have Covers checked you'll still see songs that are both A-sides and Covers. This may change in the future to allow more specific searches.

Order By: Usually just clicking on the column headers will be fine, but you can also combine them here, like
Lyrics ASC, Music ASC
Artist ASC, Seconds DESC