Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
January 26, 2006, 7:38 pm
rate this thread
UPDATE redesign.student SET student_work_area_other SELECT
REPLACE('anywhere,(.*)', '$1', i.work_area) AS regexp_col FROM
mycompany.interns i, redesign.student s WHERE i.unique_key =
s.unique_key GROUP BY work_area
Of course this does not work, but I have no idea what the MySQL
equivalent will be to something like this.
I basically want to take out PART of a column field value and update it
into another database table. How is that done?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum