Thanks Jake. Is there any way to delete likes between certain posters. Eg delete only the likes poster A gave to poster X but not to poster Y or poster Z
DELETE
FROM xf_liked_content
WHERE like_user_id = 2
AND content_user_id = 3;
Change "DELETE" to "SELECT *"
he said SELECT * <---- you left out the *
Code:SELECT * FROM xf_liked_content WHERE like_user_id = 2 AND content_user_id = 3;
Are you running this via PhpMyAdmin? There is no limit clause in the above query, but try removing the semi-colon.
SELECT liked.*, post.*, thread.*
FROM xf_liked_content AS liked
INNER JOIN xf_post AS post ON
(liked.content_id = post.post_id)
INNER JOIN xf_thread AS thread ON
(post.thread_id = thread.thread_id)
WHERE content_type = 'post'
AND like_user_id = 2
AND content_user_id = 3
SELECT post.post_id, post.thread_id, post.message, thread.title
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
WHERE post.message LIKE '%resource%'
We use essential cookies to make this site work, and optional cookies to enhance your experience.