All pastes #389984 Raw Edit

Miscellany

public sql v1 · immutable
·published 2007-03-11 02:16 UTC
rendered paste body
  SELECT SUBSTR(j.value, 8,1) AS jnum,         d.data               AS name    FROM settings AS j,         settings AS d   WHERE d.value = CONCAT("UserJobDesc", SUBSTR(j.value, 8,1))         AND LENGTH(IFNULL(j.data, "")) > 0         AND j.value LIKE "UserJob_"ORDER BY jnumjnum    name1       move_to_nas2       move_to_movie