Can anyone tell me how to UNSUBSCRIBE from this LIST.
Thanks a lot
"Matthias Urlichs" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Sinisa Milivojevic:
> > First of all, where have you got 3.23.34 when it is not out ??
> >
> It's the version in your current BitKeeper archive.
>
> > Second what type
Hi,
Sinisa Milivojevic:
> And what happens if you put quotes ??? ... id = '123'...
>
Then it works, of course. But the nice thing about the numeric select is
that it also accepts values like 123x45 or 123-45-67 (but not 1234),
which is why I wanted to use it.
--
Matthias Urlichs | nor
Matthias Urlichs writes:
> Hi,
>
>
> select * from ticketid where id like "123%"
>
> correctly uses the above index, but a more restrictive query, i.e.
>
> select * from ticketid where id like "123%" and id = 123
>
> doesn't. This is _not_ the expected result.
>
> --
Hi,
Sinisa Milivojevic:
> > >>> explain ticketid;
> > Field Type Null Key Default Extra
> > id varchar(100) PRI
> >
> > >>> show index from ticketid;
> > TableNon_unique Key_name Seq_in_index Column_name Collation
> > ticketid 0 PRIMARY
Matthias Urlichs writes:
> Hi,
>
> Sinisa Milivojevic:
> > First of all, where have you got 3.23.34 when it is not out ??
> >
> It's the version in your current BitKeeper archive.
>
> > Second what type of column is id and what does PRIMARY KEY consist of.
> >
> >>> explain ticketid
Hi,
Sinisa Milivojevic:
> First of all, where have you got 3.23.34 when it is not out ??
>
It's the version in your current BitKeeper archive.
> Second what type of column is id and what does PRIMARY KEY consist of.
>
>>> explain ticketid;
Field Type Null Key Default Extra
id var
[EMAIL PROTECTED] writes:
> >Description:
> Selecting for a number in a char table is REALLY slow.
>
> >How-To-Repeat:
> Large table, main index on column 'id' varchar(100).
>
> mysql> select id from ticketid where id = '15473';
> Empty set (0.00 sec)
>
> mysq
>Description:
Selecting for a number in a char table is REALLY slow.
>How-To-Repeat:
Large table, main index on column 'id' varchar(100).
mysql> select id from ticketid where id = '15473';
Empty set (0.00 sec)
mysql> select id from ticketid where id = 154