SQL acessing a table named with reserved keywords?

[Fteng328]

In SQL, how do you acess tables with name "match"?

"select * from match" gives me SQL syntax error.

I tried "select * from [match]","select * from "match"", "select * from 'match'". Unfortunately none of these work.

Is there a way around this? I didnt make the database schema so please dont say change the table name.

Thanks.

[xxr3376]

try `

[zorceta]

我想问的是 你是怎么用保留关键字创建表的-.-

[Fteng328]

@xxr3376 problem resolved. thx~