100000th Article

Just noticed that this is article number 100000 on the BlogEasy site. What's the chance of writing an article and then getting this number. I wonder if they are giving out prizes for this.

Selecting a Random Row from a Database Table

Here are a few ways to select a random row from a database table. These SQL statements won't require any additional application logic to pull the information you need.

Select a random row with MySQL:

SELECT column FROM table ORDER BY RAND() LIMIT 1

Select a random row with PostgreSQL:

SELECT column FROM table ORDER BY RANDOM() LIMIT 1

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table ORDER BY NEWID()

Select a random row with IBM DB2:

SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY

Select a random record with Oracle:

SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1

FireFox Extensions

Here is a great link to find all the available FireFox extensions in one place. It is very useful. Here is a really good extension for instantly displaying the Google PageRank and Alexa ranking for every site you visit.

http://extensionroom.mozdev.org/more-info/searchstatus

Another Cool FireFox Extension

Here is a link to another cool FireFox extension that allows you to block those annoying Shockwave Flash advertisements.

Create Your Own Banner

Just found a pretty cool site to help out with web development. You can create banners with text at http://header.portal.aau.dk instantly.

Web Design Patterns

Here are some good resources for using web design patterns when creating user interfaces.

An Introduction to Using Patterns in Web Design

Web Design Patterns

Web Developer Plug-In for Mozilla Browsers

FireFox and Mozilla browsers have some great plug-ins for web developers. Check out this plug-in for web developers. It is very useful.