aleniko Posted September 16, 2012 Share Posted September 16, 2012 Hi all; I have the following statement to create a temporary table: mysql_query("create temporary table curdist1 select acct,name,address1,address2,krccust.city,krccust.state,krccust.zip,krccust.tel,zips.lat,zips.lon,termtype,web,shpadrs1,shpadrs2,shpcity,shpstate,shpzip from krccust left join zips on left(krccust.zip,6)=zips.zip") ;^M After the table is created, I need to go through it and change every record which has the phrase "P.O." in the name field. I need to replace the information in the name,address1,address2,city,state,zip with the corresponding shpname,shpadrs1,shpadrs2,shpcity,shpstate,shpzip for all the records which have "P.O" in the name field. Can someone let me know what's the syntax for that? Also, I would like to know if this is achievable withing the original select statement. Thanks! Link to comment https://forums.phpfreaks.com/topic/268430-beginner-question/ Share on other sites More sharing options...
Jessica Posted September 16, 2012 Share Posted September 16, 2012 http://dev.mysql.com/doc/refman/5.0/en/update.html Link to comment https://forums.phpfreaks.com/topic/268430-beginner-question/#findComment-1378347 Share on other sites More sharing options...
aleniko Posted September 16, 2012 Author Share Posted September 16, 2012 Sorry - What are code tags? Link to comment https://forums.phpfreaks.com/topic/268430-beginner-question/#findComment-1378354 Share on other sites More sharing options...
Jessica Posted September 16, 2012 Share Posted September 16, 2012 On this forum you can post your code in special tags so it formats correctly. That is part of my signature however and wasn't to you directly. *SMH* Link to comment https://forums.phpfreaks.com/topic/268430-beginner-question/#findComment-1378359 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.