On 5/4/05, Gordon Stewart <[EMAIL PROTECTED]> wrote:
> Thanks :) Im nearly there - Not quite... though....
>
> We're using MYSQL 4.1 (I think..)
>
> - So far - I have :-
>
> $query = "SELECT * FROM BusNZ where Fleet REGEXP '-[:digit:]{6}$'";
>
it works if I take the ending off... :-
$query = "SELECT * FROM BusNZ where Fleet REGEXP '-[:digit:]{6}'";
However - I'll test tomorow - Try & see if I can put an 'end' to it...
Not tested as yet - But 7 digits will also match... (I think)... -
I'll test tomorow...
--
G Stewart
NZ Bus Website
http://busnz.kwister.com/ - Updated
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
