¹®)
S8190749|2|59000 <- ÀÌ·±½ÄÀ¸·Î |±¸ºÐÀÚ¸¦ ½á¼ ³Ö¾îÁø °ªµéÁß
°¡¿îµ¥ ºÎºÐ |¿Í|ÀÇ »çÀÌ ¼ýÀںκеéÀÇ ÇÕÀ» ±¸ÇÏ·Á°íÇÕ´Ï´Ù.
S8190749|2|59000 ¿Í °°Àº ºÎºÐ¿¡¼´Â "2"°¡ ÇØ´ç ºÎºÐÀÌ¿¹¿ä
´ä)
$result = mysql_query("SELECT SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`ÇʵåÀ̸§`, '|', 2), '|', -1)) AS `total` FROM `Å×À̺íÀ̸§`");
$row = mysql_fetch_assoc($result);
echo 'ÇÕ°è : ' . $row['total']; |
|