08.14.06
Learning New Things
The yacht club is sending out a newsletter so it’s my job to pull a list of addresses from the database. Lucky me. The thing is, I can just barely get around in SQL Land…complicated queries aren’t something I have any experience with. I finally came up with this:
SELECT CONCAT_WS(';', CONCAT_WS(' ',First,Last),StreetAddress,City,State,ZipCode) FROM WYCDatabase WHERE ExpireQtr >= 30;
This gives a list of current members in the format of:
Full Name; Street Address; City; State; ZIP
I could probably do better, but I’ll take it for now. Hopefully our newsletter person can use it or I’m going to have to manipulate the data with some scripts or something. Another thing I don’t have much experience with…regular expressions make my brain hurt.
I really shouldn’t be complaining–I’ve always meant to learn this stuff sooner or later, anyway.
Me said,
08.15.06 at 12:09 am
That’s pretty cool, actually. I hope it works too. If it doesn’t, I’m sure you could “make it work” with hardly any problem.