I am trying to first select data from a row which contains certain characters. I would then like to update and append new data into another row of those items that were selected. This is my current solution I came up with when trying to combine the two tasks into a single query.
SELECT *
FROM `parts`UPDATE `parts` SET
`keywords` = CONCAT(`keywords` , 'Phillips' )
WHERE INSTR(`name`, 'PHI') > 0