MySQl 4.03

2002-10-01 Thread DonPro
Hi, The web site states that MySQL 4.03 is still officially beta. Does anyone have any experience or feedback using it on a production system? I really require some of the new features in version 4. - Before posting, please c

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) AGAI

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 ---