[Resolved] Cannot Select Like and Order by

[ksorbo]

I am getting an error on this select query

SELECT * FROM allitems where (Fulltitle like '%Documents%') order fulltitle Limit 0,100;

fulltitle is a text field. I am wanting to find all records where fulltitle contains 'Document' and order them by fulltitle. I have created several indexes (see below).

If I remove the "order" phrase, it works.
If I remove the "where" phrase it works.
If I use the query in phpmyadmin without the order phrase, then click on the fulltitle or primaryauthor column header to sort, I get the same error.

Surely this is possible. What am I missing here?

Keith

Here is the table structure:

CREATE TABLE allitems (
id int(11) NOT NULL default '0',
body text NOT NULL,
CopyCallNo text NOT NULL,
PrimaryAuthor text NOT NULL,
AuthorList text NOT NULL,
FullTitle text NOT NULL,
PRIMARY KEY (id),
FULLTEXT KEY body (body),
KEY FullTitle (FullTitle(15)),
KEY PrimaryAuthor (PrimaryAuthor(15))
) TYPE=MyISAM;

[rachel2004]

Try using ORDER BY instead of simply ORDER:

SELECT * FROM allitems where (Fulltitle like '%Documents%') order by fulltitle Limit 0,100;