I recently took over a database as admin and am unfamiliar with the columns structure in one of the tables. I would really like to know how to select one of the values in the column, as of now I can not build a where clause using this column. The column in question is the state column, I can use any of the other columns in a where clause.
-[ RECORD 1 ]--------------------------
id | 8
name | 13
state | --- +
| :name: California +
| :abbr: CA +
|
created_at | 2011-12-08 04:31:15.104002
updated_at | 2011-12-08 04:31:15.104002