Hi!
> "Matt" == Matt Wagner <[EMAIL PROTECTED]> writes:
Matt> Paul Wisén writes:
>> This works:
>>
mysql> select trim('foo' FROM 'foobaar');
>> ++
>> | trim('foo' FROM 'foobaar') |
>> ++
>> | baar |
>> +-
I think it would have to be considered a simple bug. If you're not
convinced by the 'both' example he gave, here's one that's even more
obviously a bug:
mysql> select trim(leading 'foo' from 'foo');
++
| trim(leading 'foo' from 'foo') |
I guess I can replace it with a null string..
select REPLACE('foo', 'foo', '');
Works just fine!
Thanx!
Well, then my SET problems is fixed.
I wanted a way to add, replace or remove elements in a set without doing
it with any extra code.
fyi then, this could come handy.
To:
Add an element
Hi,
>> This works:
>>
>> mysql> select trim('foo' FROM 'foobaar');
>> ++
>> | trim('foo' FROM 'foobaar') |
>> ++
>> | baar |
>> ++
>> 1 row in set (0.00 sec)
>>
>> This does not work: !
>>
Paul Wisén writes:
> This works:
>
> mysql> select trim('foo' FROM 'foobaar');
> ++
> | trim('foo' FROM 'foobaar') |
> ++
> | baar |
> ++
> 1 row in
This works:
mysql> select trim('foo' FROM 'foobaar');
++
| trim('foo' FROM 'foobaar') |
++
| baar |
++
1 row in set (0.00 sec)
This do
