Question statement :
I better explain that I have over 6,000 question pages, each page normally has 4 questions.
I think I have not selected Multiple Correct on several hundred that have 4 possible answered with 2 or 3 correct answers.
Is there an easy way of finding questions with more than one of the answers correct but where I have not selected multiple correct?
ANSWER :
So, in multiple correct [mcc] the assumption is that the correct answer will be marked as 1,2 and in case of single correct (mcq) a 1 which is integer.
This means we can simply run a query in the database finding all the questions which are of type “mcq” but the correct answer is not an integer
I can provide the query, to update all such questions with mcc question type, all of your questions would be updated in 1 go.
SELECT
wp_meta1.post_id AS question_id,
wp_meta1.meta_value AS questionType,
wp_meta2.meta_value AS correctAnswer
FROM
wp_postmeta AS wp_meta1
LEFT JOIN
wp_postmeta AS wp_meta2
ON wp_meta1.post_id = wp_meta2.post_id
AND wp_meta2.meta_key = ‘vibe_question_answer’
WHERE
wp_meta1.meta_key = ‘vibe_question_type’
AND wp_meta1.meta_value = ‘single’
AND wp_meta2.meta_value NOT REGEXP ‘^[0-9]+$’
— ABOVE query only displays questions, Verify if the results are correct.
below query runs the UPDATE :
UPDATE wp_postmeta AS wp_meta1
JOIN wp_postmeta AS wp_meta2
ON wp_meta1.post_id = wp_meta2.post_id
AND wp_meta2.meta_key = ‘vibe_question_answer’
SET wp_meta1.meta_value = ‘multiple’
WHERE wp_meta1.meta_key = ‘vibe_question_type’
AND wp_meta1.meta_value = ‘single’
AND wp_meta2.meta_value NOT REGEXP ‘^[0-9]+$’
above answer needs to be run directly in the database.