I would like to perform a query of a personnel database with an ORDER
BY clause that ignores punctuation. For example, O'shea would sort
after Osbourne, not to the beginning of the Os.
Is this doable in the query?
-= Bill =-
--
You can tell a lot about a man by the way he
At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: "Yashesh Bhatia" <[EMAIL PROTECTED]>
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: <[EMAIL PROTECTED]>
Hello:
I had a quick question on
In one of my tables I have a start_date - timestamp (2007-07-04). A
separate column, start_yr_mo, has 200704 (first seven characters of
timestamp without the '-'). Both are entered manually. Can I define
start_yr_mo as a default of, for example, set start_yr_mo =
concat(substr(start_date, 1, 4)
