{"action":"closed","issue":{"url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/17","labels_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/17/comments","events_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/17/events","html_url":"https://github.com/yajra/laravel-datatables-oracle/issues/17","id":65192672,"number":17,"title":"Mysql protected words","user":{"login":"spajz","id":801824,"avatar_url":"https://avatars.githubusercontent.com/u/801824?v=3","gravatar_id":"","url":"https://api.github.com/users/spajz","html_url":"https://github.com/spajz","followers_url":"https://api.github.com/users/spajz/followers","following_url":"https://api.github.com/users/spajz/following{/other_user}","gists_url":"https://api.github.com/users/spajz/gists{/gist_id}","starred_url":"https://api.github.com/users/spajz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spajz/subscriptions","organizations_url":"https://api.github.com/users/spajz/orgs","repos_url":"https://api.github.com/users/spajz/repos","events_url":"https://api.github.com/users/spajz/events{/privacy}","received_events_url":"https://api.github.com/users/spajz/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-30T11:44:47Z","updated_at":"2015-04-08T00:45:37Z","closed_at":"2015-04-08T00:45:37Z","body":"Hi,\r\nI've run into a problem with column names and search part of the package. There is a problem with raw query column names and protected MySQl words (like order for example). \r\n\r\n```\r\nif ($this->isCaseInsensitive()) {\r\n                            $query->orWhere($connection->raw('LOWER(' . $cast_begin . $column . $cast_end . ')'),\r\n                                'LIKE', strtolower($keyword));\r\n                        } else {\r\n                            $query->orWhere($connection->raw($cast_begin . $column . $cast_end), 'LIKE', $keyword);\r\n                        }\r\n```\r\n\r\nSomething like this works well\r\n```\r\n $column = '`' . $column . '`';\r\n```\r\nThanks"}}