MySQL Forums
Forum List  »  Newbie

Selecting attribute with square brackets in name
Posted by: D B
Date: June 07, 2018 08:30AM

Hello,

I'm trying to do a simple SELECT FROM statement (not so simple for me I guess) but I'm having trouble because the field name I'm trying to call has square brackets in its name. The field is called:

price[1]

My code is:

SELECT STStockDetails_0.price[1]
FROM Forge.STStockDetails STStockDetails_0

Because of the square brackets it is returning a syntax error.

How can I get around this?

Thank you.

Options: ReplyQuote


Subject
Written By
Posted
Selecting attribute with square brackets in name
D B
June 07, 2018 08:30AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.