Query condtion for values not being the default value?
Yes, there is, in MySQL. You can use the DEFAULT() function:
SELECT column 
FROM table 
WHERE NOT (column &lt;=&gt; DEFAULT(column)) ;

Instead of &lt;&gt;, the NOT (.. &lt;=&gt; ..) construct that uses the null-safe equal operator &lt;=&gt; is needed for nullable columns, to have values returned when the default is NULL and null values returned when the default is not null.
Tested in SQLFiddle