How do I access a property that has spaces or special characters in it?

[abdoufma]

Hi, I have a table that contains data in this format:

{
        "content": {
          "1.0": {
            "tree": {
              "key": "value"
            }
          }
        }
}

I want to access data inside the object indexed 1.0 but I can't do a simple SELECT content['1.0'] FROM projects;
Is this even possible in surrealdb? (it's mentioned nowhere in the docs)

it would be weird if it lets me insert a data in a format that I can't query.

Thanks in advance for your help!

[eduardvercaemer]

The docs mention quoting record ids with backticks, maybe that works and if not, its maybe something that should be added.

[anonimusprogramus]

@eduardvercaemer's right, you can do a query with backtick

SELECT content.`1.0` FROM projects;

[abdoufma]

Backticks work fine, thanks for the solution 👍