Hyphen within string in mysql query causing strange behavior
===

In my rails testing environment, I have a user_id that looks like `1234-567abc89`. I'm getting inconsistent behavior by querying this user in different tables. Most of the queries are working, but running one particular query fails:

    ActiveRecord::StatementInvalid (Mysql::Error: Unknown column '1234' in 
    'where clause': SELECT * FROM `point_allocations` WHERE (user_id = 1234-567abc89) ):

So for some reason, everything beyond the hyphen is getting cut off. I realized that for the queries that work, it is looking up user `1234` instead of `1234-567abc89`, but if all the others work, any idea why only this one would return an error?