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 |
||
| Line 10: | Line 10: | ||
WHERE filters the data even more. It is a conditional. | WHERE filters the data even more. It is a conditional. | ||
UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143' | <code>UPDATE mdl_question_categories SET name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143'</code> | ||
Revision as of 04:15, 23 November 2021
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'