I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
But i keep getting the same error message
You have an error in your SQL syntax near '
table2 SET table1.periode = table2.periode WHERE table1.id = 3 AND SUBSTRIN' at line 1
Is it possible to use a SUBSTRING_INDEX in a update query, or what i am i doing wrong?
Any help is appreciated, thanks for your time
Best regards,
Davy Obdam
--
-----------------------------------------------------------------------
Davy Obdam Web application developer
Networking4all email: [EMAIL PROTECTED] email: [EMAIL PROTECTED] internet: http://www.networking4all.com -----------------------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]