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) (Created page with " UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143'") |
Walttheboss (talk | contribs) No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
From within phpmyadmin here is a handy command that you can use to change things. | |||
UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143' | 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. | |||
<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'