Javatpoint Logo
Javatpoint Logo

MySQL STRCMP() Function

The strcmp() is a String function of MySQL. This function compares the given two strings. This function returns 0 if both the strings are same, -1 if the first string is smaller than second else it returns 1.

Syntax

Parameters:

Str1 and str2: two strings to be compared

Returns:

  • If both the strings are same, this function will return 0.
  • If str1 is smaller than str2, this function will return -1.
  • If str1 is larger than str2, this function will return 1.

Example 1

Output:


MySQL String STRCMP() Function

Example 2

Output:


MySQL String STRCMP() Function

Example 3

Output:


MySQL String STRCMP() Function
Next TopicMySQL String




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

OneNote Tutorial

OneNote
Data Warehouse Tutorial

Data Ware.
VBA Tutorial

VBA
SSIS Tutorial

SSIS
NGINX Tutorial

NGINX
Blockchain Tutorial

Blockchain
ETL Tutorial

ETL
Jenkins Tutorial

Jenkins
Pytorch Tutorial

Pytorch
Agile Tutorial

Agile
JIRA Tutorial

JIRA
Tableau Tutorial

Tableau

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal A.
Interview Questions

Interview
Company Interview Questions

Company

Trending Technologies

Artificial Intelligence Tutorial

AI
AWS Tutorial

AWS
Selenium tutorial

Selenium
IoT Tutorial

IoT
Cloud tutorial

Cloud
Hadoop tutorial

Hadoop
ReactJS Tutorial

ReactJS
React Native Tutorial

React Native
Node.js tutorial

Node.js
Data Science Tutorial

D. Science
Angular 7 Tutorial

Angular 7

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

DS
DAA tutorial

DAA
Operating System tutorial

OS
Computer Network tutorial

C. Network
Compiler Design tutorial

Compiler D.
Computer Organization and Architecture

COA
Discrete Mathematics Tutorial

D. Math.
Ethical Hacking Tutorial

E. Hacking
Computer Graphics Tutorial

C. Graphics
Software Engineering Tutorial

Software E.
html tutorial

Web Tech.
Cyber Security tutorial

Cyber Sec.
Automata Tutorial

Automata
C Language tutorial

C
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control S.