unless id is an integer::
mysql>select id from testtable where id='793'
Noah Silverman wrote:
> OK,
>
> Got a weird one. The id field is an autoincremented field I use to
> index records. For some reason the system is acting like there is
> some invisible character at the end of the field. I don't know how
> that could happen since the filed is auto incremented.
>
> The problem seems intermitant. Works for some records doesn't for others.
>
> Any thoughts.
>
> -N
>
> mysql> select id from testtable where term like "%noah%";
> +-----+
> | id |
> +-----+
> | 793 |
> +-----+
> 1 row in set (0.01 sec)
>
> mysql> select file,term from testtable where id= 793 ;
> Empty set (0.00 sec)
>
> mysql> select file,term from testtable where id like "793%";
> +------+-----------+
> | file | term |
> +------+-----------+
> | 793 | noah |
> +------+-----------+
> 1 row in set (0.01 sec)
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread21107@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
