All aliases in current page

This post was last updated for 444 days ago, and the information may already be changed

I use aliases to mark examples (alias='example') how can I write a query to select all existing ones on a current page?
I try something like SELECT * FROM blocks where content='my page name' and alias='example'

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...
    • leolee9086

      image.png

      select * from blocks as A where A.root="<the page id>" and A.alias