Is there a way for me to change this select query into an update query? select t1.ID, t1.Title, t2.Title from products t1, systems t2 where t1.Title like CONCAT(t2.Title, "%")
A lot of products have the system title as the first part of the product title. I'm trying to update the product SystemID field and set it to the corresponding system ID. I'm sure there's a way to do this, but I'm not sure how. Any help is greatly appreciated. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]