I've been trying and trying to work out how I can make this UPDATE
query simpler and it's got to the point where I can't figure it out.
I want to be able to achieve changing school_id_2
or school_id_3
or school_id_4
to zero if they equal the id
in this case is 25. I want to be able to do this without running all the separate updates.
Is it possible to do this in one single UPDATE
?
Query:
$query = "
UPDATE pupil_blog_quad_overview,
pupil_blog_quad
SET pupil_blog_quad_overview.accepted = '0',
pupil_blog_quad_overview.school_id = '0',
pupil_blog_quad_overview.updated = NOW()
WHERE pupil_blog_quad_overview.school_id = '25' AND
pupil_blog_quad_overview.group_id = '58';
UPDATE pupil_blog_quad_overview,
pupil_blog_quad
SET pupil_blog_quad.school_id_2 = '0',
pupil_blog_quad.updated = NOW()
WHERE pupil_blog_quad.school_id_2 = '25' AND
pupil_blog_quad_overview.group_id = '58';
UPDATE pupil_blog_quad_overview,
pupil_blog_quad
SET pupil_blog_quad.school_id_3 = '0',
pupil_blog_quad.updated = NOW()
WHERE pupil_blog_quad.school_id_3 = '25' AND
pupil_blog_quad_overview.group_id = '58';
UPDATE pupil_blog_quad_overview,
pupil_blog_quad
SET pupil_blog_quad.school_id_4 = '0',
pupil_blog_quad.updated = NOW()
WHERE pupil_blog_quad.school_id_4 = '25' AND
pupil_blog_quad_overview.group_id = '58'";
Aucun commentaire:
Enregistrer un commentaire