{"action":"created","issue":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/7934","labels_url":"https://api.github.com/repos/joomla/joomla-cms/issues/7934/labels{/name}","comments_url":"https://api.github.com/repos/joomla/joomla-cms/issues/7934/comments","events_url":"https://api.github.com/repos/joomla/joomla-cms/issues/7934/events","html_url":"https://github.com/joomla/joomla-cms/pull/7934","id":107903721,"number":7934,"title":"Update query.php to have MySQL REPLACE command...","user":{"login":"joaobsantos","id":14371776,"avatar_url":"https://avatars.githubusercontent.com/u/14371776?v=3","gravatar_id":"","url":"https://api.github.com/users/joaobsantos","html_url":"https://github.com/joaobsantos","followers_url":"https://api.github.com/users/joaobsantos/followers","following_url":"https://api.github.com/users/joaobsantos/following{/other_user}","gists_url":"https://api.github.com/users/joaobsantos/gists{/gist_id}","starred_url":"https://api.github.com/users/joaobsantos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joaobsantos/subscriptions","organizations_url":"https://api.github.com/users/joaobsantos/orgs","repos_url":"https://api.github.com/users/joaobsantos/repos","events_url":"https://api.github.com/users/joaobsantos/events{/privacy}","received_events_url":"https://api.github.com/users/joaobsantos/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/joomla/joomla-cms/labels/PR-staging","name":"PR-staging","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-23T11:52:25Z","updated_at":"2015-09-23T16:59:24Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/joomla/joomla-cms/pulls/7934","html_url":"https://github.com/joomla/joomla-cms/pull/7934","diff_url":"https://github.com/joomla/joomla-cms/pull/7934.diff","patch_url":"https://github.com/joomla/joomla-cms/pull/7934.patch"},"body":"For example if i want to turn off help menu in joomla backend i´ll do something like this:\r\n\r\n```php\r\n//Replacing a Record\r\n\r\n$db = JFactory::getDbo();\r\n \r\n$query = $db->getQuery(true);\r\n\r\n \r\n$query->update($db->quoteName('#__modules'))\r\n\r\n      ->set($db->quoteName('params'))\r\n\r\n      ->replace('(`params`, \\'showhelp\\\":\\\"1\\', \\'showhelp\\\":\\\"0\\')')\r\n\r\n      ->where('id' .\"=\" .'12');\r\n \r\n\r\n$db->setQuery($query);\r\n \r\n$result = $db->execute();\r\n```"},"comment":{"url":"https://api.github.com/repos/joomla/joomla-cms/issues/comments/142662537","html_url":"https://github.com/joomla/joomla-cms/pull/7934#issuecomment-142662537","issue_url":"https://api.github.com/repos/joomla/joomla-cms/issues/7934","id":142662537,"user":{"login":"mbabker","id":368545,"avatar_url":"https://avatars.githubusercontent.com/u/368545?v=3","gravatar_id":"","url":"https://api.github.com/users/mbabker","html_url":"https://github.com/mbabker","followers_url":"https://api.github.com/users/mbabker/followers","following_url":"https://api.github.com/users/mbabker/following{/other_user}","gists_url":"https://api.github.com/users/mbabker/gists{/gist_id}","starred_url":"https://api.github.com/users/mbabker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbabker/subscriptions","organizations_url":"https://api.github.com/users/mbabker/orgs","repos_url":"https://api.github.com/users/mbabker/repos","events_url":"https://api.github.com/users/mbabker/events{/privacy}","received_events_url":"https://api.github.com/users/mbabker/received_events","type":"User","site_admin":false},"created_at":"2015-09-23T16:59:24Z","updated_at":"2015-09-23T16:59:24Z","body":"Ya, from that aspect I'd say you're right.  I'd use the [concatenate](https://github.com/joomla/joomla-cms/blob/3.4.4/libraries/joomla/database/query.php#L730) method as an example here."}}