Thanks for the reply. I agree on the scripting languages. However it was a one
time conversion problem. I managed with the substring_index sugestion.
Regards,
Mike
On Wednesday 11 December 2002 02:05, Robert Citek wrote:
> Hello Mike,
>
> The short answer: use Perl, Python, Ruby, etc.
>
> You are pressing the boundaries between a query language (SQL) and a
> programming/scripting language (Perl, Python, Ruby, etc.). Scripting
> languages as these already have those capabilities and can easily connect
> to MySQL an many other database. That is, if you create a solution with a
> scripting language you will also create a more portable solution.
>
> Regards,
> - Robert
>
> -----
>
> At 12:40 AM 12/11/2002 +0100, Mike Bosschaert wrote:
> >Now I want to remove the 1 or 2 letter combination from this column into
> >another column. I can select the rows with
> >
> >WHERE colX REGEXP ". .{1,2}$"
> >
> >This wil return the first two rows only. But I cannot figure out how to
> > get the query to return the matching result (being ef and i).
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
