2006/9/6, Bill Tantzen <[EMAIL PROTECTED]>:
You are actually selecting fieldA twice -- the first time (with '*') will return the entire column. The second time with only the first 20 chars. If you only want to see the first 20 chars, you will have to explicitly name every column in your select list -- you can't use '*'!
ok, I wanted to avoid to write all the fields using * I will write every single field. thanks -- http://www.spacemarc.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]