Kittiphum Worachat writes:
> Is it possible to use function such as year() in index key (like use subpart > for string field that it work) Nope, you'll have to have a column with just the information that you wish to index (except in the case of strings, of course). Also, you yourself will have to make sure that the data in that column is what it's supposed to be (with respect to what's in the longer column). //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. mysql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
