REGEXP question

#1

Hello!

I am trying to identify values in a table column that start with an
uppercase later.

select * from tw_g3 where Term RLIKE '^[A-Z]{1}.+'

But I get all the columns (also those that start with a lower case.

Whats wrong?

Thanks

Michael

#2

On 10 mar, 18:57, Michael Preminger <michaelprem... (AT) gmail (DOT) com> wrote:

Quote:

Hello!

I am trying to identify values in a table column that start with an
uppercase later.

select * from tw_g3 where Term RLIKE '^[A-Z]{1}.+'

But I get all the columns (also those that start with a lower case.

Whats wrong?

See:

http://dev.mysql.com/doc/refman/5.1/...nsitivity.html

/Lennart

#3

On 10 Mar, 17:57, Michael Preminger <michaelprem... (AT) gmail (DOT) com> wrote:

Quote:

Hello!

I am trying to identify values in a table column that start with an
uppercase later.

select * from tw_g3 where Term RLIKE '^[A-Z]{1}.+'

But I get all the columns (also those that start with a lower case.

Whats wrong?

Thanks

Michael

SELECT * will always give all the columns.

#4

Captain Paralytic:

Quote:

On 10 Mar, 17:57, Michael Preminger <michaelprem... (AT) gmail (DOT) com> wrote:
Hello!

I am trying to identify values in a table column that start with an
uppercase later.

select * from tw_g3 where Term RLIKE '^[A-Z]{1}.+'

But I get all the columns (also those that start with a lower case.

Whats wrong?

SELECT * will always give all the columns.

I assume Michael meant to say: all the rows.

--
Erick

#5

On 3/12/2010 6:15 AM, Erick T. Barkhuis wrote:

Quote:

Captain Paralytic:

On 10 Mar, 17:57, Michael Preminger<michaelprem... (AT) gmail (DOT) com> wrote:
Hello!

I am trying to identify values in a table column that start with an
uppercase later.

select * from tw_g3 where Term RLIKE '^[A-Z]{1}.+'

But I get all the columns (also those that start with a lower case.

Whats wrong?

SELECT * will always give all the columns.

I assume Michael meant to say: all the rows.

He was correct in his statement, but adding 'all the rows' would of
expounded on it also.

Scotty

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

REGEXP question

comp.databases.mysql comp.databases.mysql

REGEXP question - 03-10-2010 , 11:57 AM

Re: REGEXP question - 03-10-2010 , 12:20 PM

Re: REGEXP question - 03-12-2010 , 08:13 AM

Re: REGEXP question - 03-12-2010 , 08:15 AM

Re: REGEXP question - 03-13-2010 , 08:02 AM