-- 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\\_]+$'; 

http://www.mywebsite.com/blog/videos.html

1.  http://www.mywebsite.com/blog/videos.html 

http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos

1.  http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos 

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; 

UserFolder:="C:"
-- UserFolder := RegExReplace( MyInputField, "\\$")  ; gets rid of trailing slash if required

-- Method #1
count := 0
Loop, %UserFolder%\*.*, 0, 1 
  count++

-- note for future use:
; if A_LoopFileAttrib contains H,R,S
;	continue

1.  UserFolder:="C:" 
2.  -- UserFolder := RegExReplace( MyInputField, "\\$")  ; gets rid of trailing slash if required 
3.   
4.  -- Method #1 
5.  count := 0 
6.  Loop, %UserFolder%\*.*, 0, 1 
7.    count++ 
8.   
9.  -- note for future use: 
10.  ; if A_LoopFileAttrib contains H,R,S 
11.  ;    continue