|
|
|
|
Joined: Apr 2002
Posts: 474
Enthusiast
|
|
Enthusiast
Joined: Apr 2002
Posts: 474 |
I am trying to figure out the correct syntax to do a search and replace on the
subject....
I got the find working...
SELECT *
FROM `w3t_Posts`
WHERE `B_Subject`
LIKE '[FP7] %'
Now I want the '[FP7]' to be changed to '[FM7]'
|
|
|
|
|
Joined: Oct 2000
Posts: 2,223
Veteran
|
|
Veteran
Joined: Oct 2000
Posts: 2,223 |
this is not going to be exact but it will look something like this
UPDATE w3t_Posts SET B_Subject = REPLACE(B_Subject, '[FP7]', '[FM7]');
Picture perfect penmanship here.
|
|
|
|
|
Joined: Apr 2002
Posts: 474
Enthusiast
|
|
Enthusiast
Joined: Apr 2002
Posts: 474 |
This will not destroy anything else will it?
|
|
|
|
|
Joined: Apr 2001
Posts: 3,266
Member
|
|
Member
Joined: Apr 2001
Posts: 3,266 |
|
|
|
|
|
Joined: Apr 2002
Posts: 474
Enthusiast
|
|
Enthusiast
Joined: Apr 2002
Posts: 474 |
Forgot to come back and say thanx... 
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
