[thelist] mysql error using select to update

[Bob Meetin]

tried that, just didn't report back.

mysql> set @attribs = select attribs from jos_content where id=119;
ERROR 1064 (42000): 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 'select attribs from jos_content where id=119' at line 1
mysql>

mysql version 5 i do believe

r937 wrote:
>> mysql> set @attribs := select attribs from jos_content where id=119;  
>> --> fails with syntax error
>>     
>
> remove da colon
>
> ;o)
>