mmmm, as far as i can see, from mysql 5.0 and upper it is possible create index using functions.
http://www.faqs.org/docs/ppbook/r24254.htm But i keep having problems with the exemple from the link. Is there any bug in mysql 5.0.24a-log? 2007/11/13, Martijn Tonies <[EMAIL PROTECTED]>: >mysql> create index AA on precalc (IDR(P1,P4,P6,P7,P9,'HLA-DRB13')); > > > >But i Get the following error: > > > >ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual > >that corresponds to your MySQL server version for the right syntax to use > >near ''P1','P4','P6','P7','P9','HLA-DRB13'))' at line 1 > > > >Some one knows where is the error? > > As far as I can see ( > http://dev.mysql.com/doc/refman/5.0/en/create-index.html ) > you can only use columns, not a function. > > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle > & > MS SQL Server > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : [EMAIL PROTECTED]