bunnywong

UPDATE oc_order_product SET reward = total 
	WHERE  name LIKE  '%以上%' 
	AND (quantity * price - reward) < 0

bunnywong

SELECT *, (quantity * price - reward)  AS rewardDiff
	FROM  `oc_order_product` 
	WHERE  `name` LIKE  '%以上%'
	AND (quantity * price - reward) < 0
	ORDER BY rewardDiff

bunnywong

----- SELECT -----
Ctrl Shfit  + A           = Select inner <tag>

----- ADD -----
Alt Shfit + W             = Create new <tag>

----- REMOVE -----
Ctrl Shfit + K            = Remove tail <tag>
Ctrl K , Ctrl + backspace = Del to head
Ctrl K, Ctrl K,           = Del to end

bunnywong

.field-item {
    position: relative;
    padding-bottom: 56.25%; /* - 16:9 aspect ratio (most common) */
    /* padding-bottom: 62.5%; - 16:10 aspect ratio */
    /* padding-bottom: 75%; - 4:3 aspect ratio */
    padding-top: 30px;
    height: 0;
    overflow: hidden;
}