PHP Constants Containing Arrays? – Stack Overflow

by ⋅ Leave a Comment ⋅ Link

PHP Constants Containing Arrays? – Stack Overflow

You can also serialize your array and then put it into the constant:

# define constant, serialize array
define ("FRUITS", serialize (array ("apple", "cherry", "banana")));

# use it
$my_fruits = unserialize (FRUITS);

mysql – How to return multi-count of specific values – Stack Overflow

by ⋅ Leave a Comment ⋅ Link

mysql – How to return multi-count of specific values – Stack Overflow

예시)

SELECT SUM(CASE WHEN category = 0 THEN 1 ELSE 0 END) AS cat0count,
       SUM(CASE WHEN category = 1 THEN 1 ELSE 0 END) AS cat1count,
       SUM(CASE WHEN category = 2 THEN 1 ELSE 0 END) AS cat2count,
       SUM(CASE WHEN category = 3 THEN 1 ELSE 0 END) AS cat3count
    FROM YourTable

mysql – How to return multi-count of specific values – Stack Overflow

by ⋅ Leave a Comment ⋅ Link

mysql – How to return multi-count of specific values – Stack Overflow

예시)

SELECT SUM(CASE WHEN category = 0 THEN 1 ELSE 0 END) AS cat0count,
       SUM(CASE WHEN category = 1 THEN 1 ELSE 0 END) AS cat1count,
       SUM(CASE WHEN category = 2 THEN 1 ELSE 0 END) AS cat2count,
       SUM(CASE WHEN category = 3 THEN 1 ELSE 0 END) AS cat3count
    FROM YourTable

sql – How do I check if a column is empty or null in mysql – Stack Overflow

by ⋅ Leave a Comment ⋅ Link

sql – How do I check if a column is empty or null in mysql – Stack Overflow

This will select all rows where some_col is NULL or '' (empty string)

SELECT * FROM table WHERE some_col IS NULL OR some_col = '';

sql – How do I check if a column is empty or null in mysql – Stack Overflow

by ⋅ Leave a Comment ⋅ Link

sql – How do I check if a column is empty or null in mysql – Stack Overflow

This will select all rows where some_col is NULL or '' (empty string)

SELECT * FROM table WHERE some_col IS NULL OR some_col = '';