Rails query boolean MySQL error

Question

Doing any one of these:

notifications.where("read = 'true'")
notifications.where("read = '1'")
notifications.where("read = true")
notifications.where("read = 1")

results in the error:

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read = 'true')

However, this works just fine:

notifications.where(:read => true)

Any idea why this could be?

Community · Accepted Answer · 2017-05-23 11:57:35Z

1

read is mysql reserved keyword you need to use back-ticks around your column name

notifications.where(" `read` = true")

Not familiar with ruby but you can refer to this answer to enclose the column with back-ticks

Mysql Reserved Words

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Feb 16, 2014 at 6:10

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Snowman Over a year ago

Oh wow ok. Is it safe to use it still or should I user another name?

M Khalid Junaid Over a year ago

Best practice is use the meaning full column name like user_read or notification_read so it has the minimal chance to produce such type of errors and you can easily use the column names without back-ticks

Collectives™ on Stack Overflow

Rails query boolean MySQL error

1 Answer 1

Mysql Reserved Words

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related