How can I make a table in MySQL called "order"?

Question

When I make a MySQL table order, it is created successfully but, when I execute any query against it, it says "error 1064 , syntax error".

When I change the name to orders, it works fine.

But I don't want to change the name. How can I execute our query against the order table?

Answer 1

can you use something like?

select * from `order`