IT/Software/Database Applications/phpMyAdmin: Difference between revisions
Access restrictions were established for this page. If you see this message, you have no access to this page.
Walttheboss (talk | contribs) No edit summary |
Walttheboss (talk | contribs) No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 11: | Line 11: | ||
<code>UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143'</code> | <code>UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143'</code> | ||
<code>UPDATE mdl_question_categories SET sortorder = '1' WHERE parent = '4230'</code> | |||
<br /> | |||
Latest revision as of 14:46, 19 August 2022
From within phpmyadmin here is a handy command that you can use to change things.
UPDATE means to do something to change the table
SET names the field or column
REPLACE is of the form field,from,to
WHERE filters the data even more. It is a conditional.
UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143'
UPDATE mdl_question_categories SET sortorder = '1' WHERE parent = '4230'