In general:
BSD - do what you like with it, just don't advertise your product as being endorsed by the authors http://en.wikipedia.org/wiki/BSD%5Flicenses
MIT - do what you like with it
Creative Commons - Depends on the type (see below)
(1) Attribution - Do what you like with it, but acknowledge the author(s)
(2) Noncommercial - Do what you like with it, but don't sell it
(3) No derivative works - You can use it as long as you don't modify it or create a work derived
from it
(4) Sharealike - Distribution of this or derivative works must comply to the original license
(5) Combinations of (1) to (4)
http://en.wikipedia.org/wiki/Creative%5FCommons%5Flicenses
Mozilla public license - It's complicated http://www.mozilla.org/MPL/mpl-faq.html
Apache license - Do more or less what you want with it (with some restrictions)
http://en.wikipedia.org/wiki/Apache%5FLicense
GPL - Do whatever you want with it, but if you modify it and distribute it in any way, you MUST
release the source code under the GPL. If any of your code contains GPL licensed code, your entire source code must be released under the GPL
LGPL - Mostly applies to libraries, you can link against a library or include the source code in your application as long as you do not modify the source code. Modified code must be released under the LGPL http://en.wikipedia.org/wiki/GNU%5FGeneral%5FPublic%5FLicense and http://en.wikipedia.org/wiki/GNU%5FLesser%5FGeneral%5FPublic%5FLicense
Please note, IANAL.