Question about FULLTEXT indexes

2002-10-01 Thread DonPro
Hi, I'm using MySQl 3.23.52 on RedHat Linux 6.2 I have a table that is indexed on the description column as FULLTEXT. I allow the user to enter text in an input field and I return matching rows. I've noticed that writing a query such as: SELECT EDescript FROM HSCodes WHERE MATCH(EDescript)

Key in reverse order

2002-07-30 Thread DonPro
Hi, I have a MySQL table key on a 7 character VarChar field. Th efile contains numeric characters only which I've inserted right justified. Is there any way to travres the table/key in reverse order so that it displays highest to lowest? I wish to use this in a SELECT query. Thanks, Don