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


---------------------------------------------------------------------
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

Reply via email to