The original table I wanna query contains no index, while I wanna add index to make the final display more user-friendly.
I first tried it in mysql and it worked like this which is great and convenient.
However, when I put the same sql query into “system.db.runQuery”, there exists an error in the sql query:
I also tried named query using the same way to set a variable but it failed too.
I know there are other ways that allow me to add index to the display table, but for me , to add it in the query is the most ideal method and I really wanna make it work.
Looking forward to your help, guys!!!