On Fri, Aug 17, 2001 at 03:46:11PM +0100, Lee Denny wrote:
> Hello,
>
> Can any one tell me why
>
> $sql="SELECT * FROM table WHERE pcsort REGEXP '^".$parts[0]."[0-9]'";
> (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.)
>
> works OK in 3.23 but not in 3.22.
>
> I'm trying to find UK postcodes such as e17 but not ee17.
It was probably a bug fixed along the way...
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 0 days, processed 11,210,313 queries (177/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
