n Title like 'An %' then substring (Title, 4, 255)
> else Title
> end
>
> That worked like a charm, yet MySQL doesn't seem to accept that. Any
> solutions or advice?
--
Petr Tuma
IT Manager, M.Ward Manufacturing
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi,
there was an typing error 'from Title' should be 'from Titles'. Anyway it's
working for me.
What error message it produce?
On Thursday 01 November 2001 05:09, you wrote:
> Petr Tuma wrote:
> > select *,(case when Title like 'The %' then subs
in case it will not work find out
in the 'list of changes' (for version 3.23) if this feature is not new. In
such case tell whoever to upgrade. :(
I can't find any error in your query (and at least at 3.23 it's working!)
Regards
On Thursday 01 November 2001 10:19, you wrote:
f a beer.
> Yea, Ah woke up this mornin' an' I had myself a beer.
> The futures' uncertain and the end is always near.
> -Jim Morrison, "Roadhouse Blues"
>
> Fill with mingled cream and amber,
> I will drain that glass again.
> Such hil