How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains '' (NULL) = No match
Field BBB contains ' ' (one charter) = No match
Field CCC contains 'ab' = Match
Field DDD contains 'abcdefg' = Match
Niklas
Assuming you're using MySQL - 35 seconds is all it took to find:
http://www.mysql.com/doc/P/a/Pattern_matching.html
Good luck!
Russ.
On Thu, 25 Oct 2001 14:16:40 +0300 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
[EMAIL PROTECTED]
wrote:
How can I query for specified fields that has to contain atleast
REGEXP '..+'
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 6:17 AM
To: Php-DB
Subject: [PHP-DB] mySQL Query and blank fields
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains
On Thursday 25 October 2001 13:16, Niklas Lampén wrote:
How can I query for specified fields that has to contain atleast 2
charters?
SELECT * FROM foo_table WHERE length(bar_field)=1;
Arpi
Example:
Field AAA contains '' (NULL) = No match
Field BBB contains ' ' (one charter) = No
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message-
From: Tamas Arpad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:01 AM
To: Niklas Lampén; Php-DB
Subject: Re: [PHP-DB] mySQL Query and blank fields
On Thursday 25 October 2001 13:16
' not '98765' as I expected.
Niklas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 25. lokakuuta 2001 15:56
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message
?
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:04 AM
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Thanks a lot! I quite didn't know what to look for in the manual.
I actually have another question:
If I want to update
On Thursday 25 October 2001 15:08, Rick Emery wrote:
First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM
foo_table WHERE fieldname REGEXP '..+'
It's quicker.
regular expression is faster then a length() call? that's seems
strange considering how complex a regexp can be
with