2 messages in com.mysql.lists.mysqlQuick REGEXP problem
FromSent OnAttachments
Lee Denny17 Aug 2001 07:45 
Jeremy Zawodny17 Aug 2001 17:52 
Subject:Quick REGEXP problem
From:Lee Denny (le@areality.co.uk)
Date:08/17/2001 07:45:49 AM
List:com.mysql.lists.mysql

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