IT/Software/Database Applications/phpMyAdmin

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'