In MySQL, LIKE is allowed on numeric expressions. : LIKE : String Functions MySQL TUTORIALS

MySQL TUTORIALS » String Functions » LIKE »

In MySQL, LIKE is allowed on numeric expressions.


mysql>
mysql> SELECT 10 LIKE '1%';
+--------------+
| 10 LIKE '1%' |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

expr LIKE pat [ESCAPE 'escape_char']
To test for literal instances of a wildcard character, precede it by the escape character.
To specify a different escape character, use the ESCAPE clause
String comparisons are not case sensitive unless one of the operands is a binary string

MySQL TUTORIALS

String Functions
» LIKE

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

Privilege

Subquery

Table

Table Join

Trigger

View

In MySQL, LIKE is allowed on numeric expressions. : LIKE : String Functions MySQL TUTORIALS

MySQL TUTORIALS » String Functions » LIKE »

In MySQL, LIKE is allowed on numeric expressions.

Leave a Comment / Note

MySQL TUTORIALS