1 SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM {access} WHERE type = '%s' AND LOWER('%s') LIKE LOWER(mask) ORDER BY status DESC
转载于:https://www.cnblogs.com/droko/archive/2011/12/02/2272044.html
1 SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM {access} WHERE type = '%s' AND LOWER('%s') LIKE LOWER(mask) ORDER BY status DESC
转载于:https://www.cnblogs.com/droko/archive/2011/12/02/2272044.html