Tag Archives: mysql function

UNIX_TIMESTAMP

ShareUNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) If called with no argument, returns a Unix timestamp (seconds since ’1970-01-01 00:00:00′ UTC) as an unsigned integer. If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since ’1970-01-01 00:00:00′ … Continue reading

Posted in mysql | Tagged , , , , | Leave a comment

ISNULL() in mysql

ShareSELECT * FROM table1 LEFT JOIN table2 ON table2 .folder_id = table1.id WHERE members_folders.mem_id=’1100′ AND ISNULL(table2.id) -get records from table1 that doesn’t have a record on table2 ISNULL() – Test whether the argument is NULL source: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_isnull

Posted in mysql | Tagged , , | Leave a comment

CONCAT_WS

ShareCONCAT_WS(separator,str1,str2,…) CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be … Continue reading

Posted in anything under the moonlight, mysql | Tagged , | Leave a comment