: LIKE : String Functions MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
String Functions
»
LIKE
»
423.1 .
In MySQL, LIKE is allowed on numeric expressions.
Hits: 1553
423.2 .
String comparisons are not case sensitive unless one of the operands is a binary string
Hits: 973
423.3 .
To specify a different escape character, use the ESCAPE clause
Hits: 1046
423.4 .
To test for literal instances of a wildcard character, precede it by the escape character.
Hits: 2846
423.5 .
expr LIKE pat [ESCAPE 'escape_char']
Hits: 983
MySQL TUTORIALS
String Functions
»
LIKE
Introduction
LPAD
ASCII
LTRIM
BIN
MAKE_SET
BIT_LENGTH
MID
CHAR
ORD
CHARSET
QUOTE
CHAR_LENGTH
REGEXP
CONCAT
REPEAT
CONCAT_WS
REPLACE
ELT
REVERSE
EXPORT_SET
RIGHT
FIELD
RPAD
FIND_IN_SET
RTRIM
FORMAT
SOUNDEX
HEX
SOUNDS LIKE
INSERT
SPACE
INSTR
STRCMP
LCASE
SUBSTRING
LEFT
SUBSTRING_INDEX
LENGTH
TRIM
LIKE
UCASE
LOAD_FILE
UNHEX
LOCATE
UPPER
LOWER
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
In MySQL, LIKE is allowed on numeric expressions.
