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
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.
All the best,
Lee
--
