Search results
16 sty 2011 · I am trying to find an equivalent of DECODE function in MySQL. It works like this: Select Name, DECODE(Age, 13,'Thirteen',14,'Fourteen',15,'Fifteen',16,'Sixteen', 17,'Seventeen',18,'Eighteen',19,'Nineteen', 'Adult') AS AgeBracket FROM Person
13 lis 2019 · Learn how to use the MySQL DECODE function to decode an encoded string and return the original string. See syntax, parameters, return value and examples of the DECODE function.
8 sie 2023 · DECODE() function . MySQL DECODE() function decodes an encoded string and returns the original string. Syntax: DECODE(crypt_str, pass_str); Arguments:
15 maj 2023 · The MySQL DECODE() function is known to be a decryption type of function in the database for data interpretation. This MySQL DECODE function is responsible to decode an encrypted string part from the record values and then returns the original one.
28 kwi 2022 · This tutorial presents the three alternative implementations that we can use as the equivalent of Oracle’s decode() function in MySQL. For that, we will use IF() , CASE , and the combination of FIELD() and ELT() .
See the description of TO_BASE64() for details about the encoding and decoding rules. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')); -> 'JWJj', 'abc' If FROM_BASE64() is invoked from within the mysql client, binary strings
SELECT DECODE (3, 1, 'Equal 1,', 2, 'Equal 2', 'Not Equal 1 or 2'); Code language: SQL (Structured Query Language) (sql) This example works like the following IF-THEN-ELSEIF-ELSE statement: IF 3 = 1 THEN RETURN 'Equal 1'; ELSE IF 3 =2 THEN RETURN 'Equal 2'; ELSE RETURN 'Not Equal 1 or 2'; END IF ; Code language: SQL (Structured Query Language ...
