If you're only changing the one field an UPDATE foo SET bar query will be more efficient here. And the same syntax works for the other database types too (they just use different quoting structures).

@mbabker
Will try

Thanks @alikon :)

We need here one more test to RTC.

@test
Tested successfuly on a fresh installation. Submenutitle/COM_CONTACT_CONTACTS could be overwritten while the mainmenu stays the same.

I have tested this item ✅ successfully on f3795d0

(finally found the 'Test this'-button ;)

RTC as we have 2 good tests

Just updated a Joomla installation (in a test environment) from 3.4.8 to 3.5 (using MySQL). The title of menu item with ID 8 was changed from "Geschiedenis" to "com_contact_contacts" as stated in this PR.
The changed menu item is shown on the frontend, so it is not the backend menu item which should be updated. I think I got a frontend menu item with ID 8 because I'm running this site since Joomla 1.5. A long time ago I migrated to 2.5 (and updated every release since then).

I think other people with (somehow) non-default menu item IDs may/will have the same problem. My proposal is to only change the title for menu items which matches the follow criteria:
a) only backend menu items (client_id = 1)
b) with title = 'com_contact'
c) in a submenu (level = 2)

For MySQL the following query does the job from phpMyAdmin:
UPDATE jml_menu SET title = 'com_contact_contacts' WHERE client_id = 1 AND level = 2 AND title = 'com_contact'

If you agree I wil be happy to change the queries and submit another PR. I also can help testing for MySQL because I did not upgrade my production installation yet.

@ratenfanger you are commenting on a pull request that was merged five months ago

@brianteeman sorry I thought this was the correct place to discuss my findings. Should I create a new issue and mention this PR?