[thelist] 2 Tips: MySQL

Frank lists at frankmarion.com
Tue Feb 3 21:49:50 CST 2004

<tip type="MySQL" author="Frank Marion">

It's very useful to get familiar with your favourite database's built in 
function. I needed a quick way to get unique names and email addresses out 
of a big mished, mashed and abused database. I could have spent 20 minutes 
setting up a script for it in my programming language, but it seemed faster 
to do it with MySQL's built in functions. To wit:

SELECT DISTINCT CONCAT(first_name,' ',last_name,' <',email_address,'>')
from client_info;

Total time: 30 seconds.


<tip type="MySQL" author="Frank Marion">

If you want a quick and easy reference to learn MySQL functions, check out 
the following URL:


You'll find that MySQL is very well documented, and in a wide variety of 

Softcover book, published by O'Reilly
Searchable, with user comments
HTML, one page per chapter
HTML, one page per chapter, tarball
HTML, all on one page, tarball
HTML, all on one page, ZIP
PDF (US letter)
PDF (A4)
Windows HLP
Windows CHM

The site itself organises the information very well, and even more 
usefully, you can download the documentation. My favourite is the .chm 
document. It's quick to load, and has a search function that allows you to 
find what you want though the concept index almost instantly.


Frank Marion     lists at frankmarion.com      Keep the signal high.  

More information about the thelist mailing list