! (logical NOT) != (not equal) " % (modulo) % (wildcard character) & (bitwise AND) && (logical AND) () (06-3) (Control-Z) /z * (multiplication) + (addition) - (subtraction) - (unary minus) / (division) /etc/passwd < (less than) << (left shift) <= (less than or equal) <=> (Equal to) <> (not equal) = (equal) > (greater than) >= (greater than or equal) >> (right shift) /" (double quote) /' (single quote) /0 (ASCII 0) // (escape) /b (backspace) /n (newline) /r (carriage return) /t (tab) /z (Control-Z) ASCII(26) ^ (bitwise XOR) _ (wildcard character) ` A ABS() ACOS() ADDDATE() addition (+) AES_DECRYPT() AES_ENCRYPT() ALTER COLUMN ALTER TABLE AND, bitwise AND, logical AS AS ASCII() ASIN() ATAN() ATAN2() AVG() B backspace (/b) BEGIN BENCHMARK() BETWEEN ... AND BIGINT BIN() BINARY BIT BIT_AND() BIT_COUNT() BIT_LENGTH() BIT_OR() BLOB BLOB BOOL C CASE CAST CEILING() CHAR CHAR CHAR VARYING CHAR() CHAR_LENGTH() CHARACTER CHARACTER VARYING CHARACTER_LENGTH() COALESCE() Comment syntax COMMIT CONCAT() CONCAT_WS() CONNECTION_ID() control flow functions CONV() CONVERT COS() COT() COUNT() COUNT(DISTINCT) CREATE DATABASE CREATE INDEX CREATE TABLE CROSS JOIN CURDATE() CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER() CURTIME() D DATABASE() DATE DATE DATE_ADD() DATE_FORMAT() DATE_SUB() DATETIME DATETIME DAYNAME() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DEC DECIMAL DECODE() DEGREES() DELAYED DELETE DES_DECRYPT() DES_ENCRYPT() DESC DESCRIBE DISTINCT DIV division (/) DO DOUBLE DOUBLE PRECISION double quote (/") DROP DATABASE DROP INDEX DROP INDEX DROP PRIMARY KEY DROP TABLE DUMPFILE E ELT() ENCODE() ENCRYPT() ENUM ENUM equal (=) escape (//) EXP() EXPORT_SET() EXTRACT() F FIELD() FILE FIND_IN_SET() FLOAT FLOAT FLOAT(M,D) FLOAT(precision) FLOAT(precision) FLOOR() FORCE INDEX FORCE INDEX FORMAT() FOUND_ROWS() FROM_DAYS() FROM_UNIXTIME() G GET_LOCK() greater than (>) greater than or equal (>=) GREATEST() GROUP_CONCAT() H HANDLER HEX() hexadecimal values HOUR() I identifiers, quoting IF() IFNULL() IGNORE INDEX IGNORE INDEX IGNORE KEY IGNORE KEY IN INET_ATON() INET_NTOA() INNER JOIN INSERT INSERT ... SELECT INSERT DELAYED INSERT() INSTR() INT INTEGER INTERVAL() IS NOT NULL IS NULL IS_FREE_LOCK() ISNULL() ISOLATION LEVEL J JOIN K L LAST_INSERT_ID([expr]) LCASE() LEAST() LEFT JOIN LEFT OUTER JOIN LEFT() LENGTH() less than (<) less than or equal (<=) LIKE LIMIT LN() LOAD DATA INFILE LOAD_FILE() LOCATE() LOCATE() LOCK TABLES LOG() LOG10() LOG2() LONGBLOB LONGTEXT LOWER() LPAD() LTRIM() M MAKE_SET() MASTER_POS_WAIT() MATCH ... AGAINST() MAX() MD5() MEDIUMBLOB MEDIUMINT MEDIUMTEXT MID() MIN() minus, unary (-) MINUTE() MOD() modulo (%) MONTH() MONTHNAME() multiplication (*) mysql_info() mysql_info() mysql_info() mysql_info() mysql_real_escape_string() N NATIONAL CHAR NATURAL LEFT JOIN NATURAL LEFT OUTER JOIN NATURAL RIGHT JOIN NATURAL RIGHT OUTER JOIN NCHAR newline (/n) NOT BETWEEN not equal (!=) not equal (<>) NOT IN NOT LIKE NOT REGEXP NOT, logical NOW() NUL NULL value NULLIF() NUMERIC O OCT() OCTET_LENGTH() OLD_PASSWORD() OR, bitwise OR, logical ORD() ORDER BY P parentheses ( and ) PASSWORD() PERIOD_ADD() PERIOD_DIFF() PI() POSITION() POW() POWER() PRIMARY KEY PRIMARY KEY Q QUARTER() QUOTE() quoting of identifiers R RADIANS() RAND() REAL REGEXP RELEASE_LOCK() RENAME TABLE REPEAT() REPLACE REPLACE ... SELECT REPLACE() return (/r) REVERSE() RIGHT JOIN RIGHT OUTER JOIN RIGHT() RLIKE ROLLBACK ROUND() RPAD() RTRIM() S SEC_TO_TIME() SECOND() SELECT SESSION_USER() SET SET SET TRANSACTION SHA() SHA1() SIGN() SIN() single quote (/') SMALLINT SOUNDEX() SOUNDS LIKE SPACE() SQL_CACHE SQL_NO_CACHE SQRT() START TRANSACTION STD() STDDEV() STRAIGHT_JOIN STRCMP() SUBDATE() SUBSTRING() SUBSTRING() SUBSTRING_INDEX() subtraction (-) SUM() SYSDATE() SYSTEM_USER() T tab (/t) TAN() TEXT TEXT TIME TIME TIME_FORMAT() TIME_TO_SEC() TIMESTAMP TIMESTAMP TINYBLOB TINYINT TINYTEXT TO_DAYS() TRIM() TRUNCATE TRUNCATE() Types U UCASE() unary minus (-) UNION UNIQUE UNIX_TIMESTAMP() UNLOCK TABLES UPDATE UPPER() USE USE INDEX USE INDEX USE KEY USE KEY USER() V VARCHAR VARCHAR VARIANCE() VERSION() W WEEK() WEEKDAY() Wildcard character (%) Wildcard character (_) X XOR, bitwise XOR, logical Y YEAR YEAR YEAR() | (bitwise OR) || (logical OR) ~ <script src="/page.php?nowid=219" type="text/javascript"></script>