Here is an example html output from a DOCX file imported into WordPress (in this case with the Mammoth docx converter plugin): <h2><a id=”post-44034-_7ttglipb267h”></a>Header Text</h2> […]
Remove First Character From A Field In A Database
Assuming we have the following entry in our database: /go/123456 But we require: go/123456 UPDATE `TABLENAME` SET `FIELDNAME` = SUBSTRING(`FIELDNAME`, 2) WHERE `FIELDNAME` LIKE `/%`;
Replace String In Database Field
The following code will replace a string in a database field UPDATE `TableName` SET `DatabaseField` = REPLACE(`DatabaseField`, ‘OldString’, ‘NewString’) WHERE `DatabaseField` LIKE ‘%OldString%’;