I assume that
UPDATE categories SET categories_status = 1 where categories_id = XX; would do it.