MySQL equivalent of DECODE function in Oracle

You can use IF() where in Oracle you would have used DECODE().

mysql> select if(emp_id=1,'X','Y') as test, emp_id from emps;

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. ORA-00904: invalid identifier
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Case statement in MySQL
  5. Error Code: 2013. Lost connection to MySQL server during query
  6. how to drop partition without dropping data in MySQL?
  7. What is it exactly a BLOB in a DBMS context
  8. How do I reset a sequence in Oracle?
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  11. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  12. Unknown column in ‘field list’ error on MySQL Update query
  13. Unknown column in ‘field list’ error on MySQL Update query
  14. Self Join to get employee manager name
  15. how to fix oracle ORA-01722 invalid number error
  16. MySQL – Operand should contain 1 column(s)
  17. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  18. MySQL create table if not exists and insert record only if table was created
  19. ORA-00979 not a group by expression
  20. ORA-00907: missing right parenthesis
  21. How do I use properly CASE..WHEN in MySQL
  22. Why do we need “Relationships” between tables at all?
  23. How can I do a FULL OUTER JOIN in MySQL?
  24. MySQL query String contains
  25. What’s the difference between VARCHAR and CHAR?
  26. How to declare a variable in MySQL?
  27. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  28. ORA-01843 not a valid month- Comparing Dates
  29. MySQL Cannot Add Foreign Key Constraint
  30. How do I restore a dump file from mysqldump?
  31. ORA-00918: column ambiguously defined in SELECT *
  32. Oracle error : ORA-00905: Missing keyword
  33. How to split the name string in mysql?
  34. What does SQL Select symbol || mean?
  35. How do I import an SQL file using the command line in MySQL?
  36. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  37. mysql Foreign key constraint is incorrectly formed error
  38. How do I limit the number of rows returned by an Oracle query after ordering?
  39. Oracle SELECT TOP 10 records
  40. MySQL: Invalid use of group function
  41. Can a foreign key be NULL and/or duplicate?
  42. How to Select Top 100 rows in Oracle?
  43. How can I return pivot table output in MySQL?
  44. ORA-12560: TNS:protocol adaptor error
  45. Compare dates in MySQL
  46. MySQL “WITH” clause
  47. What is the difference between JOIN and UNION?
  48. MySQL Multiple Joins in one query?
  49. MySQL syntax for Join Update
  50. ORA-00972 identifier is too long alias column name
  51. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  52. Oracle Apex column link from LOV values
  53. PLS-00103: Encountered the symbol when expecting one of the following:
  54. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  55. ORA-00918: column ambiguously defined in SELECT *
  56. ORA-00918: column ambiguously defined in SELECT *
  57. 1052: Column ‘id’ in field list is ambiguous
  58. 1052: Column ‘id’ in field list is ambiguous
  59. difference between primary key and unique key
  60. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  61. MySQL combine two columns into one column
  62. ORA-01861: literal does not match format string
  63. Simple way to calculate median with MySQL
  64. Creating a search form in PHP to search a database?
  65. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  66. Error 1046 No database Selected, how to resolve?
  67. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  68. MySQL Error 1264: out of range value for column
  69. How do you create a temporary table in an Oracle database?
  70. Oracle “Partition By” Keyword
  71. How to insert date values into table
  72. Oracle SQL: Update a table with data from another table
  73. Oracle SQL query for Date format
  74. Remove duplicate rows in MySQL
  75. How to SUM and SUBTRACT using SQL?
  76. The backend version is not supported to design database diagrams or tables
  77. Create mysql table directly from CSV file using the CSV Storage engine?
  78. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  79. Cast from VARCHAR to INT – MySQL
  80. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  81. SQL selecting rows by most recent date with two unique columns
  82. How do you force mysql LIKE to be case sensitive?
  83. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  84. MySQL – UPDATE multiple rows with different values in one query
  85. Postgres Error: More than one row returned by a subquery used as an expression
  86. How to create a MySQL hierarchical recursive query?
  87. ERROR 1148: The used command is not allowed with this MySQL version
  88. Insert into a MySQL table or update if exists
  89. How to round down to nearest integer in MySQL?
  90. Comparing Dates in Oracle SQL
  91. Convert timestamp to date in Oracle SQL
  92. MySQL starts with searching issue
  93. Query to convert from datetime to date mysql
  94. Is it possible to GROUP BY multiple columns using MySQL?
  95. MySQL error: key specification without a key length
  96. Update statement with inner join on Oracle
  97. Best way to test if a row exists in a MySQL table
  98. Check if MySQL table exists without using “select from” syntax?
  99. mysql update column with value from another table
  100. The used SELECT statements have a different number of columns

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)