ThisDate    ThisDay     StartTime  TimeOut  TimeIn  EndTime  TotalTimeToday TotalTimeWeek
----------- ----------- ---------- -------- ------- -------- -------------- -------------
2013-12-02  Monday      09:00      12:00    13:00   17:00    7:00           7:00
2013-12-03  Tuesday     08:45      12:00    13:30   17:45    7:30           14:30
2013-12-04  Wednesday   09:00      12:30    13:30   17:00    7:00           21:30
2013-12-05  Thursday    10:00      12:15    12:45   17:15    7:45           29:15
2013-12-06  Friday      07:00      12:00    13:00   16:30    8:30           37:45
2013-12-07  Saturday    -          -        -       -        0:00           37:45
2013-12-08  Sunday      03:00      04:00    -       -        4:00           41:45

1.  ThisDate    ThisDay     StartTime  TimeOut  TimeIn  EndTime  TotalTimeToday TotalTimeWeek 
2.  ----------- ----------- ---------- -------- ------- -------- -------------- ------------- 
3.  2013-12-02  Monday      09:00      12:00    13:00   17:00    7:00           7:00 
4.  2013-12-03  Tuesday     08:45      12:00    13:30   17:45    7:30           14:30 
5.  2013-12-04  Wednesday   09:00      12:30    13:30   17:00    7:00           21:30 
6.  2013-12-05  Thursday    10:00      12:15    12:45   17:15    7:45           29:15 
7.  2013-12-06  Friday      07:00      12:00    13:00   16:30    8:30           37:45 
8.  2013-12-07  Saturday    -          -        -       -        0:00           37:45 
9.  2013-12-08  Sunday      03:00      04:00    -       -        4:00           41:45 

-- return all records that contain non-alphanumeric characters
SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$';

-- return all records that are non-alphanumeric but ignore underscores
SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9\\_]+$';

1.  -- return all records that contain non-alphanumeric characters 
2.  SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; 
3.   
4.  -- return all records that are non-alphanumeric but ignore underscores 
5.  SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9\\_]+$'; 

SELECT
        EmployeeNo
        , DaysOffSick
        , DateOfSickness
FROM    Employees_Attendance_Table


-- yields

        EmployeeNo      DaysOffSick     DateOfSickness
        --------------  --------------  ----------------
        001             1.00            1997-11-17
        002             3.00            2000-02-18
        003             2.00            1999-02-25

1.  SELECT 
2.          EmployeeNo 
3.          , DaysOffSick 
4.          , DateOfSickness 
5.  FROM    Employees_Attendance_Table 
6.   
7.   
8.  -- yields 
9.   
10.          EmployeeNo      DaysOffSick     DateOfSickness 
11.          --------------  --------------  ---------------- 
12.          001             1.00            1997-11-17 
13.          002             3.00            2000-02-18 
14.          003             2.00            1999-02-25 

EmployeeNo      DaysOffSick     DateOfSickness
--------------  --------------  ----------------
001             1.00            1997-11-17
002             1.00            2000-02-18
002             1.00            2000-02-19
002             1.00            2000-02-20
003             1.00            1999-02-25
003             1.00            1999-02-26

-- note the dates increment and do not account for days off (eg. Saturday / Sunday)

1.  EmployeeNo      DaysOffSick     DateOfSickness 
2.  --------------  --------------  ---------------- 
3.  001             1.00            1997-11-17 
4.  002             1.00            2000-02-18 
5.  002             1.00            2000-02-19 
6.  002             1.00            2000-02-20 
7.  003             1.00            1999-02-25 
8.  003             1.00            1999-02-26 
9.   
10.  -- note the dates increment and do not account for days off (eg. Saturday / Sunday) 

-- where @ThisSearch is a posted (and sanitized) variable

SET @ThisSearch:="Brains";

SELECT
        columnID,
        columnFullName,
        CASE
                WHEN columnFirstName LIKE @ThisSearch THEN 20
                WHEN columnFullName LIKE @ThisSearch THEN 10
                WHEN columnLastName LIKE @ThisSearch THEN 10
                WHEN columnFullName LIKE @ThisSearch THEN 1
        END as relevance
FROM
        myTable
WHERE
        s.columnPublished

1.  -- where @ThisSearch is a posted (and sanitized) variable 
2.   
3.  SET @ThisSearch:="Brains"; 
4.   
5.  SELECT 
6.          columnID, 
7.          columnFullName, 
8.          CASE 
9.                  WHEN columnFirstName LIKE @ThisSearch THEN 20 
10.                  WHEN columnFullName LIKE @ThisSearch THEN 10 
11.                  WHEN columnLastName LIKE @ThisSearch THEN 10 
12.                  WHEN columnFullName LIKE @ThisSearch THEN 1 
13.          END as relevance 
14.  FROM 
15.          myTable 
16.  WHERE 
17.          s.columnPublished 

-- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
ALTER TABLE myTable ADD myColumn CHAR(2) NULL

-- Delete a column
ALTER TABLE myTable DROP COLUMN myColumn 

-- Reorder a column
ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;

1.  -- Add a column to an existing table (giving it datatype char(2) and allowing null) 
2.  ALTER TABLE myTable ADD myColumn CHAR(2) NULL 
3.   
4.  -- Delete a column 
5.  ALTER TABLE myTable DROP COLUMN myColumn 
6.   
7.  -- Reorder a column 
8.  ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;