John,
> > > I can see no explanation in the data stored in the table.
> > The important thing is what MySQL 'sees'!
> >
> > You've already started testing your premise << > are
> > either "input" or "published">>> One suggestion would be to use the
> > MySQL client for investigations, then if you
I ran the following command to change the status field from a varchar
text to ENUM("Input","Published") NOT NULL
$sql = "ALTER TABLE $table_name
CHANGE status
status ENUM(\"Input\",\"Published\") NOT NULL
";
The changes took effect according to the comm
Have you tried running these from the command line mysql client, to see what
may be up? Maybe you have a variable in your code that's not getting
re-initialized properly.
If you get the same results from the mysql client, it might be time to run
myisamchk on your table. (or just dump the data, dr
--- DL Neil <[EMAIL PROTECTED]> wrote:
> John,
>
> > I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> > results are the same as when I attempt = \"published\"
> >
> > Something in the query processing works differently when = is
> used in
> > the WHERE.
> >
> > I can see no expla
John,
> I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> results are the same as when I attempt = \"published\"
>
> Something in the query processing works differently when = is used in
> the WHERE.
>
> I can see no explanation in the data stored in the table.
The important thing
I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
results are the same as when I attempt = \"published\"
Something in the query processing works differently when = is used in
the WHERE.
I can see no explanation in the data stored in the table.
John Hughes
--- Jeff Kilbride <[EMAIL
--- Georg Richter <[EMAIL PROTECTED]> wrote:
> On Saturday, 2. March 2002 09:32, John Hughes wrote:
> > I have a table with approximately 600 rows. Two of the fields are
> > "record_date" and "status" Every record has an entry in the
> > "record_date" in -00-00 format. The "status" is eithe
On Saturday, 2. March 2002 09:32, John Hughes wrote:
> I have a table with approximately 600 rows. Two of the fields are
> "record_date" and "status" Every record has an entry in the
> "record_date" in -00-00 format. The "status" is either "input"
> or "published" (I DID NOT create this colu
If your condition that the status field only contains two values holds true,
then there should be no difference in the two queries you have below -- that
I can see, unless someone can prove me blind...
Are you *absolutely* sure none of the columns contain extra spaces, nulls,
etc...? You might tr
