Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
otd
Starting Member
2 Posts |
 Posted - 2007-09-27 : 05:24:13
|
| Good Morning Folks,Pretty new to Mysql, and have a query that if anyone can help me with id be very grateful!!I am using the UPDATE command and wish to copy a columns data to another column, but the first column contains text then (text in a bracket) i wish to copy everything from the first column except whats in the bracket to column 2???example...UPDATE table_name SET `field1` = `field2`...............???Any ideas??Many Thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-27 : 05:26:07
|
| <<Pretty new to Mysql>>This is SQL Server Forum. You should post Mysql related questions at www.mysql.comMadhivananFailing to plan is Planning to fail |
 |
|
|
otd
Starting Member
2 Posts |
Posted - 2007-09-27 : 05:28:03
|
| Appologies didnt realise..if any anyone does know the answer to this though would be very grateful |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-27 : 05:31:08
|
quote:
Originally posted by otd
Appologies didnt realise..if any anyone does know the answer to this though would be very grateful
Search for LOCATE command in mysql help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
UPDATE command help?? exclude text in brackets..