I was trying to google for searching a database for a nil yaml value and it took me a bit so I thought I would post my findings. Basically if you do this in the rails console:
|
1 |
nil.to_yaml |
you’ll receive:
|
1 |
--- \n...\n |
Kind of irritating when you’re trying to write a SQL query. So to check for a null column in the traditional sense as well as YAML, you can do so with the following query:
|
1 2 3 4 |
SELECT * FROM my_table WHERE my_column IS NULL OR my_column = '--- ... ' |
Enjoy!