Help mysql query to change post/thread owner

[postcd]

Hello,

i have two users who posted topics where they mention phrasse: news.google.com

my aim is either delete such posts (but it seems to be too complicated as you can see there (https://vborg.vbsupport.ru/showthread.php?t=319001)) or to change these topics/posts owner/user using mysql query.

SELECT * FROM `post` WHERE `pagetext` LIKE '%news.google.com%'
it found 2 users which have matching posts:

username: username1, username2
userid: 479, 0
pagetext: %news.google.com%

(username2 had userid 308 before i wrongly removed his account, keeping his posts)

SELECT * FROM `thread` WHERE `postusername` LIKE 'username1' AND `postuserid` LIKE '308' AND `replycount` LIKE '0' AND `notes` LIKE 'Imported thread'
This found posts i want to attribute to different user with id example: 308.

So as a total mysql noob, i tried:
UPDATE `thread` SET `postuserid` = '308' WHERE `postusername` LIKE 'username2' AND `postuserid` LIKE '308' AND `replycount` LIKE '0' AND `notes` LIKE 'Imported thread'
but is wrong. Can you please help with right mysql query/ies to change user id of the topics/posts that contain phrasse news.google.com? Thank you

[Dave]

LIKE is used to check if a column contains a string, but your usage in the UPDATE query is wrong and I don't think that's what you really want to use anyway.

To match a value, you use =.
WHERE postusername = 'username2' AND postuserid = 308 AND replycount = 0 AND notes = 'Imported thread'.

Just keep in mind that you also need to update the userid in the post table. (First post of the thread)

[Seven Skins]

Don't know if this is what you are looking for.

SELECT * FROM `post` WHERE `pagetext` LIKE '%news.google.com%' AND `userid` = 0;

update `post` SET `userid` = '308' WHERE `pagetext` LIKE '%news.google.com%' AND `userid` = 0


See attachments for the results.. both queries returned same number of results.



https://vborg.vbsupport.ru/attachment.php?attachmentid=156739&stc=1&d=1511626364
https://vborg.vbsupport.ru/attachment.php?attachmentid=156740&stc=1&d=1511626364