야쿠이야기

Matching a Valid Email Address $email = 'editor@thedaily.com' if (!preg_match('^[_A-Za-z0-9-]+(\\.[_A-Za-z0-9-]+)*@[A-Za-z0-9]+(\\.[A-Za-z0-9]+)*(\\.[A-Za-z]{2,})$^', $email)) { echo 'The email address you entered was invalid.'; } Matching a string between 4 and 128 characters $string = "tutorial"; if (!preg_match('#^(.){4,128}$#', $string)) { echo 'The string you entered is invalid.'; } Matchin..

업데이트 시 조건에 따라 업데이트 하는 방법 Max( 0, (balance - void_credit) ) UPDATE [account] SET balance = ( CASE WHEN ((balance - 10.00) < 0) THEN 0 ELSE (balance - 10.00) END ) WHERE id = 1

SET @cnt := 0; SELECT @cnt := @cnt + 1 AS No, COL1 from TABLE;