Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? --
Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 4/9/2008 at 2:17 PM, in message <[EMAIL PROTECTED]>, "Martijn Tonies" <[EMAIL PROTECTED]> wrote: >> Thanks for the answer but that's not it. It was my typo. I am really > updating and selecting from the same table. > > Perhaps "not it" either, but strings should be in single quotes, not double > quotes. > > Martijn Tonies > Database Workbench - development tool for MySQL, and more! > 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]