All aliases in current page

This post was last updated for 225 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'

    Related articles

    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