What Am I Doing Wrong? Please Help!

[Greywacke]

i'm no mysql pro, but it doesn't make sense why the following would not work in PMA...should i perhaps be converting the number to a string to use in the CONCAT function? if so how would i do this?

UPDATE 8_transactionsSET (	text_TransactionEvent)VALUES (	CONCAT("Lead #",(bigint_LeadID+11001000)," Sent"))WHEREtext_TransactionEvent LIKE "%11001000%"

okay, i'd have to use the CAST function - not working replaced with CONVERT, implemented it as follows:

UPDATE 8_transactionsSET (8_transactions.text_TransactionEvent)VALUES (	CONCAT("Lead #", CONVERT(8_transactions.bigint_LeadID + 11001000, CHAR), " Sent")) WHERE 8_transactions.text_TransactionEvent LIKE "%11001000%";

this however, now gives the following result in PMA:

#1064 - 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 '(8_transactions.text_TransactionEvent) VALUES (CONCAT("Lead #", CONVERT(8_transa' at line 1

oh duh. i keep getting muddled with the syntax of INSERT and UPDATE statements :)issue resolved.