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 |
||
| Line 1: | Line 1: | ||
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 name = REPLACE(name,'Biology ','Biology') WHERE parent = '4143' | ||
Revision as of 15:42, 22 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'