MySQL SIGN Function

MySQL SIGN function is one of the Numeric Function which is used to return sign of the specified expression. And the return value will be either Positive (+1), Negative (-1), or Zero (0). In this article we will show you, How to find the sign of a value in MySQL using Command Prompt, and Workbench with example.

MySQL SIGN Syntax

The basic syntax of the SIGN in MySQL is as shown below:

SELECT SIGN (Numeric_Expression)
FROM Source

• If the Expression is Zero, SIGN function will return Zero as result.
• If the Numeric_Expression is Negative Number, function will return Negative One(-1) as result.
• And If the Expression is positive Number, SIGN function will return Positive One(+1) as result.

To demonstrate this SIGN Numeric function, we are going to use the below shown data

MySQL SIGN Function Example 1

The SIGN Function is used to find and return the sign of a specified value. The following MySQL query will show multiple ways to use SIGN function.

-- MySQL SIGN Function Example

-- Finding Sign for Negative Value
SELECT SIGN(-240.75) AS `Sign Value`;

-- Finding Sign for Positive Value
SELECT SIGN(125.267) AS `Sign Value`;

-- Finding Sign for Zero
SELECT SIGN(0) AS `Sign Value`;

-- Sign of string value
SELECT SIGN('125.274') AS `Sign Value`;

-- Sign Example on String
SELECT SIGN('MySQL') AS `Sign Value`;

-- Sign Example on NULLs
SELECT SIGN('NULL') AS `Sign Value`;

From the below screenshot you can see, we used SIGN function on different values. Here, we assigned a new name to the result as ‘Sign Value’ using ALIAS Column.

and

MySQL SIGN Example 2

In MySQL, SIGN Numeric Function also allows you to check the sign value for the column data. In this example, we are going to find the sign value for all the records present in Service Grade column.

-- MySQL SIGN Function Example
USE mysqltutorial;
SELECT Product, Color,
		StandardCost, Sales, TaxAmt,
        ServiceGrade,
        SIGN(ServiceGrade) AS `Grade Sign`
FROM `numeric functions`;

OUTPUT

Thank You for Visiting Our Blog