UPDATE post
SET pagetext = REPLACE(pagetext, 'thsnks', 'thanks')
WHERE userid=123
Goal is to change each post from this particular user from misspelled "thsnks" to correct-spelling...
Announcement
Collapse
No announcement yet.
Search Result
Collapse
9 results in 0.0117 seconds.
Keywords
Members
Tags
-
Is this correct? UPDATE post SET pagetext = REPLACE(pagetext, 'thsnks', 'thanks') WHERE userid=123
-
Queries for Inline Moderation Tools for posts?
Please provide available queries for Inline Moderation Tools for "posts" - ie: approve, unapprove, move, delete, etc.
For example, seeking to "unapprove" all posts from...
-
Query; to edit all Redirects to Expiring Redirect?
Query; to edit all Redirects to Expiring Redirect?
ie; From permanent to Expires in 1 Hours?
-
Query; to open all closed threads within a certain forum?
Query; to open all closed threads within a certain forum?
Leave a comment: