{"action":"created","issue":{"url":"https://api.github.com/repos/gabordemooij/redbean/issues/429","labels_url":"https://api.github.com/repos/gabordemooij/redbean/issues/429/labels{/name}","comments_url":"https://api.github.com/repos/gabordemooij/redbean/issues/429/comments","events_url":"https://api.github.com/repos/gabordemooij/redbean/issues/429/events","html_url":"https://github.com/gabordemooij/redbean/issues/429","id":65259586,"number":429,"title":"Is it possible to escape a colon in a bound parameters, to prevent it from being treated as a bound parameter?","user":{"login":"r3wt","id":4483325,"avatar_url":"https://avatars.githubusercontent.com/u/4483325?v=3","gravatar_id":"","url":"https://api.github.com/users/r3wt","html_url":"https://github.com/r3wt","followers_url":"https://api.github.com/users/r3wt/followers","following_url":"https://api.github.com/users/r3wt/following{/other_user}","gists_url":"https://api.github.com/users/r3wt/gists{/gist_id}","starred_url":"https://api.github.com/users/r3wt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r3wt/subscriptions","organizations_url":"https://api.github.com/users/r3wt/orgs","repos_url":"https://api.github.com/users/r3wt/repos","events_url":"https://api.github.com/users/r3wt/events{/privacy}","received_events_url":"https://api.github.com/users/r3wt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-03-30T17:22:32Z","updated_at":"2015-04-01T18:56:45Z","closed_at":null,"body":"In the screenshot, i'm using Regular expression to search in a table that contains some json. problem is, when adding a bound parameter to the query, it treats the json seperator : as the start of a new named parameter. is there a work around for this?\r\n\r\n**Fig1: Query is valid**\r\n![img](http://puu.sh/gVmsl/d791e121ac.png)\r\n**Fig2: Redbean seems to be treating the colon in the REGEXP as a bound parameter**\r\n![img2](http://puu.sh/gVmRW/9c1f2afb0a.png)"},"comment":{"url":"https://api.github.com/repos/gabordemooij/redbean/issues/comments/88594464","html_url":"https://github.com/gabordemooij/redbean/issues/429#issuecomment-88594464","issue_url":"https://api.github.com/repos/gabordemooij/redbean/issues/429","id":88594464,"user":{"login":"r3wt","id":4483325,"avatar_url":"https://avatars.githubusercontent.com/u/4483325?v=3","gravatar_id":"","url":"https://api.github.com/users/r3wt","html_url":"https://github.com/r3wt","followers_url":"https://api.github.com/users/r3wt/followers","following_url":"https://api.github.com/users/r3wt/following{/other_user}","gists_url":"https://api.github.com/users/r3wt/gists{/gist_id}","starred_url":"https://api.github.com/users/r3wt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r3wt/subscriptions","organizations_url":"https://api.github.com/users/r3wt/orgs","repos_url":"https://api.github.com/users/r3wt/repos","events_url":"https://api.github.com/users/r3wt/events{/privacy}","received_events_url":"https://api.github.com/users/r3wt/received_events","type":"User","site_admin":false},"created_at":"2015-04-01T18:56:45Z","updated_at":"2015-04-01T18:56:45Z","body":"no, i'm using stable release downloaded from redbean website with wget"}}