Clever Geek Handbook

Mysql () , /?

Mysql ( , MSSQL), , (MYSQL),

Table_name   STATUS_DATE = STR_TO_DATE (substring_index (SSTATUS_DATE, "", 1), '% c/% e/% Y'),

- , . , , "" ? , , ? , CABANA , , substr , , , , ? .. , ?

+2




2


-

SELECT ID, SSTATUS_DATE TABLE_NAME, (substring_index (SSTATUS_DATE, "", 1) REGEXP '^ [0-9] +/[0-9] +/[0-9] + $');



, 00/00/00.

+2




UDF WHERE .



CREATE FUNCTION IsDate (str VARCHAR(256))
    RETURNS INT
BEGIN
    DECLARE result INT;

    IF ( SELECT LENGTH(DATE(str)) IS NULL ) THEN
        SET result = 0;
    ELSE
        SET result = 1;
    END IF;

    RETURN tp;
END
0








More articles:


All Articles