On 9/11/08, Ryan Stille <[EMAIL PROTECTED]> wrote:
>
> Thank you for the link Darryle, but I don't think you read through my whole
> question. I have already read through that page, and I see how to use regex
> as a condition for a select. What I am interested in is applying a regex to
> a column
Thank you for the link Darryle, but I don't think you read through my
whole question. I have already read through that page, and I see how to
use regex as a condition for a select. What I am interested in is
applying a regex to a column as I select it.Selecting a varchar
column with all t
>-Original Message-
>From: Darryle Steplight [mailto:[EMAIL PROTECTED]
>Sent: Thursday, September 11, 2008 10:00 AM
>To: Ryan Stille
>Cc: mysql@lists.mysql.com
>Subject: Re: Selecting a column with a regular expression applied to it?
>
>Hi Ryan,
>
>MySql does
Hi Ryan,
MySql does have regular expressions. See Link
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille <[EMAIL PROTECTED]> wrote:
> From looking at the MySQL 5 docs, it doesn't look like there is any way to
> select a column with a regular expressio
From looking at the MySQL 5 docs, it doesn't look like there is any way
to select a column with a regular expression applied to it?
I have a column that has ended up with some non ascii characters in it,
probably vertical tabs and things like that from MS Excel. I need to
sort by this field b
27;);
I have no idea if that's possible.
-Original Message-
From: tweewan.wong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 10:27 PM
To: [EMAIL PROTECTED]
Subject: RE: Selecting a Column
Not sure why you don't get "Tuesday". At my place ( I am using 5.1 beta
Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: 24 March 2004 09:33
To: [EMAIL PROTECTED]
Subject: Re: Selecting a Column
So what are you asking? I'm confused. Are you asking just to get
'Tuesday'? (SELECT DAYNAME('2004-03-23');)
So what are you asking? I'm confused. Are you asking just to get
'Tuesday'? (SELECT DAYNAME('2004-03-23');) The value of Tuesday where
inventoryid = 1? (SELECT DAYNAME('2004-03-23') FROM inventoryRoom WHERE
inventoryid='1'; which you already had.) Or all the values in Tuesday?
(SELECT DAYNAME('
Hi,
I have a table that looks like this:
CREATE TABLE inventory (
inventoryid int(11) NOT NULL,
sunday int(3),
monday int(3),
tuesday int(3),
wednesday int(3),
thursday int(3),
friday int(3),
saturday int(3),
PRIMARY KEY (inventoryid)
);
And I'm trying to run a command like
SELECT DAYNAME('2004
