Jordan Brough Stuff I found online.

Posts tagged mysql

Looking at Twitter’s Historical Trend Data

I think trends are one of the most interesting by-products of the Twitter revolution. It is so interesting to capture the collective minds of the world and collapse them down to ten terms. @karmadude and I have begun experimenting with Twitter’s historical trend data using their search API. We have a lot [...]


Selecting a Random Row From a SQL Database

There are plenty of ways to select random records from a database, here are a few simple statements that don’t require any advanced logic.
Select a random row with MySQL:
[snippet=11412]
Select a random row with PostgreSQL:
[snippet=11414]
Select a random row with Microsoft SQL Server:
[snippet=11415]
Select a random row with IBM DB2
[snippet=11416]
Select a random record with Oracle:
[snippet=11417]
Have you got other [...]


Handy (free) Web Development Cheat Sheets

After digging around the internets for a good list of HTML character entities I remembered finding and printing off their great Regular Expression cheat sheet at work and thougth there was a chance they might have a sheet for characters too.  How could I forget the name of the site… I Love Jack Daniels.