[RESOLVED] Extract rows via regex

PaPPy

I am trying to extract rows that are 15 characters long and only contain A-Za-z

i tried some preg_match going thru an if statement, but it didnt work.

how would i do it and what is the fastest way?

sorry forgot to add, im using mysql

johanafm

http://dev.mysql.com/doc/refman/5.1/en/regexp.html#operator_regexp

PaPPy

tried

SELECT *from names where Username REGEXP '^[A-Z]';

not sure what im supposed to do

ive also tried

SELECT * from users where Username REGEXP '^[A-Z]{15}$'

but i still get lower case, my feild is set to varchar and latin1_swedish_ci

if i need to change something let me know

ok someone else helped and gave me this query and seems to work

SELECT `your_username_field_here` FROM `your_table_name_here` WHERE char_length(`your_username_field_here`) = 12 AND `your_username_field_here` = UPPER(`your_username_field_here`) COLLATE latin1_general_cs AND `your_username_field_here` REGEXP '^[A-Z]' ORDER BY `your_username_field_here` ASC

thanks all, and thanks aMUSiC!

nevvermind

Regexp in MySQL?! I'm in!

First of all, I'll quote something, from this page:

In MySQL, SQL patterns are case-insensitive by default.

If you really want to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string.

This meaning that it makes no sense to query using e regex like this:

SELECT * FROM `users` WHERE `Username` REGEXP '^[A-Za-z]{15}$'

It's still going to find you names containing upper- AND lower-case characters. The above pattern works exactly like this one:

SELECT * FROM `users` WHERE `Username` REGEXP '^[a-z]{15}$'

Yups. This too will find you names which contain some (or none, or all) upper-case letters.

"So how do you match case-sensitive style?", I hear so asking. You've guessed it: REGEXP BINARY.

SELECT * FROM `users` WHERE `Username` REGEXP BINARY '^[A-Z]{15}$'

The above query matches any 15-character long names that are all - and, by God , I mean ALL - uppercase.

PS: Thx, btw. I've learned something today. Didn't know all that stuff I've just wrote you. :rolleyes: I just hope I'm right.
PPS: The back ticks (`) in the query it's just me being precautious.