Return random records in MySQL

Works only for relatively small tables.

SELECT field1, field2, field3 FROM mytable WHERE status = 1 AND otherfield = 'somevalue' ORDER BY RAND();

One of many sources:
http://davidwalsh.name/return-random-records-mysql

 Well, well, well, look at that

Even the suburbs has entertainment on some days.

Doyle and I were talking about something at work, when he perked up, pointed at me and said, "Hey! Look at that!" I took a moment's pause before I realized he was pointing over my shoulder and out the office window. That pause was longer than the one I took to grab my camera and start taking photos.



 Various endings

Various endings and their sources

EndingSourceExamples
-eratorVA, Arielschemerator
-sterNapsterFriendster, Dogster
-z0rAndy Smithandyz0r, blogz0r, kittz0r
-zillaMozilla?Bugzilla, Hudzilla

-storm, beginning: i-

 Defense hurts.

From http://sports.espn.go.com/espn/page2/story?page=neel/040614

By Eric Neel
Page 2

AUBURN HILLS, Mich. -- Defense is a mother.

Defense hurts.

There's no glory in it. There's no rest. There's no air in your lungs and there are all kinds of burn in your legs.

Defense measures you, from scrambling feet to searching eyes to beating heart. It takes all you have and asks for more, and it won't reward you until you're spent, and sometimes not even then.

You want to play defense -- I mean really play it -- then you have to make like the old-time saints, maintaining faith and be willing to sacrifice and endure anything and everything with nothing but the promise, the hope, of deliverance.

Scoring says what you can do. Shutting the other team down, closing lanes, contesting passes and shots, and letting them know, by the way you breathe up into them and stare right through them, that you're in it for the long haul ... that says who you are.

...

"It's tough to come out of your comfort zone," Dumars says. "We all live in a box in this world. We are who we are for the most part, and to have somebody come in and say, 'I want you to do, and to be, something different and I want you to do it in front of 20 thousand people every night,' that's not easy, man."

Eric Neel is a regular columnist for Page 2. He will file daily from the NBA Finals, and his "On Baseball" column appears weekly during the baseball season.



 Planting sunshine

From http://www.bhg.com/bhg/story.jhtml?storyid=/templatedata/bhg/story/data/yellow_flowers_032904.xml

Planting Sunshine with Yellow Flowers

Don't be afraid of the boldness of yellow in your garden. Embrace its sunny disposition.

Yellow can be brash and bold, but it deserves a place in every
yard. When used sparingly and in combination with contrasting
colors, this golden hue can light up a garden. You can intensify
yellow's bold tendencies by pairing it with red, orange, or
lavender. Or group it with pink or green for a more subtle
combination.

Hues of yellow are at their best in the spring, fall, and
winter. The blazing summer sun often causes yellow to appear
washed-out and drab. The lower light intensity of the other three
seasons is friendlier toward golden hues and they respond by
practically glowing.

Spring abounds with yellow. From cheery daffodils to tiny
crocus peeking through the snow, bulbs offer many yellow hues.
Shrubs such as forsythia can also be counted on for yellow spring
blossoms.
[image:102,right]

Summer offers up many yellow annuals and perennials,
including yarrow (Achillea millefolium), sunflowers
(Helianthus), sundrops (Oenothera perennis), and
lilies.

Fall is ablaze with yellow leaf color. For yellow flower
color, look to coneflower (Rudbeckia), tickseed
(Coreopsis), and goldenrod (Solidago).

Winter is a time when colorful yellow barks really shine.
Dogwood (Cornus stolonifera 'Flaviramea') and willow
(Salix alba var. vitellina) both have yellow winter shoots.
And when left standing, ornamental grasses will turn a deep gold
color.

The Yellow Top 10

When you want yellow in the garden, you have a wide variety of
annuals and perennials to choose from. Here are our picks for the
easiest to grow:

  • Zinnia (Zinnia elegans). This cut-flower favorite
    is easy to grow from seed sown in the garden, and stands up well to
    heat.
  • Black-eyed Susan vine (Thunbergia alata).
    Although it resembles its earth-bound cousin, this fast-growing
    vine produces flowers from spring through fall.
  • Pot marigold (Calendula officinalis), an
    orange-yellow cool-season annual.
  • Dalberg daisy (Thymophylla tenuiloba). This
    ferny-leafed annual produces cheery yellow blooms all summer.
  • Basket of gold (Aurinia saxatilis). Low-growing
    plant covered with tiny gold flowers in early spring.
  • Primrose (Primula auricula). In cooler climates,
    grow these as annuals for summer bloom. In the far south, they
    bloom throughout the winter.
  • Cushion spurge (Euphorbia polychroma). This
    low-maintenance summer-flowering perennial features blue-green or
    variegated leaves that look great even when the attractive flowers
    are done blooming.
  • California poppy (Eschscholzia calilfornica).
    This spring-blooming flower is grown as an annual in most
    locations. It is most at home in a rock garden or naturalized in a
    meadow.
  • Leopardsbane (Doronicum). Pretty yellow
    daisy-like flowers appear in May. During hot weather, the plant may
    appear to die back, but it will return.
  • Painted tongue (Salpiglossis sinuata). Imagine
    petunia flowers with veins of contrasting color running through the
    blooms and you'll have a picture of this annual.

Syndicate content