SQL Error 1292 trying to update row field

manpreet Best Answer 2 years ago

I'm com/tag/try">trying to update a field called "Syllabus" using this SQL query:

UPDATE `cursos` c
SET c.SYLLABUS = 'https://www.upv.es/pls/oalu/sic_asi.Busca_Asi?
P_VISTA=&P_IDIOMA=i?p_codi=' + c.CODE + '&p_caca=act'
WHERE c.SYLLABUS LIKE "" AND c.CENTER NOT LIKE "Study Abroad"

But I'm getting this weird error saying I'm com/tag/try">trying to input a DOUBLE com/tag/value">value on line 2 whenever I com/tag/try">try to execute it. Any suggestions on how I could fix this problem?

manpreet 2 years ago

UPDATE cursos c
    SET c.SYLLABUS = CONCAT('https://www.upv.es/pls/oalu/sic_asi.Busca_Asi?P_VISTA=&P_IDIOMA=i?p_codi=',
                            c.CODE, '&p_caca=act')
WHERE c.SYLLABUS = '' AND c.CENTER NOT LIKE 'Study Abroad';