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. Self Join to get employee manager name
  13. how to fix oracle ORA-01722 invalid number error
  14. MySQL – Operand should contain 1 column(s)
  15. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  16. ORA-00979 not a group by expression
  17. How do I use properly CASE..WHEN in MySQL
  18. How can I do a FULL OUTER JOIN in MySQL?
  19. MySQL query String contains
  20. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  21. MySQL Cannot Add Foreign Key Constraint
  22. How do I restore a dump file from mysqldump?
  23. ORA-00918: column ambiguously defined in SELECT *
  24. Oracle error : ORA-00905: Missing keyword
  25. How to split the name string in mysql?
  26. What does SQL Select symbol || mean?
  27. How do I import an SQL file using the command line in MySQL?
  28. mysql Foreign key constraint is incorrectly formed error
  29. How do I limit the number of rows returned by an Oracle query after ordering?
  30. MySQL: Invalid use of group function
  31. Can a foreign key be NULL and/or duplicate?
  32. Compare dates in MySQL
  33. MySQL “WITH” clause
  34. What is the difference between JOIN and UNION?
  35. MySQL Multiple Joins in one query?
  36. ORA-00972 identifier is too long alias column name
  37. PLS-00103: Encountered the symbol when expecting one of the following:
  38. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  39. ORA-00918: column ambiguously defined in SELECT *
  40. ORA-00918: column ambiguously defined in SELECT *
  41. 1052: Column ‘id’ in field list is ambiguous
  42. 1052: Column ‘id’ in field list is ambiguous
  43. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  44. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  45. MySQL Error 1264: out of range value for column
  46. How do you create a temporary table in an Oracle database?
  47. Oracle “Partition By” Keyword
  48. Oracle SQL: Update a table with data from another table
  49. Oracle SQL query for Date format
  50. How to SUM and SUBTRACT using SQL?
  51. The backend version is not supported to design database diagrams or tables
  52. Create mysql table directly from CSV file using the CSV Storage engine?
  53. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  54. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  55. SQL selecting rows by most recent date with two unique columns
  56. How do you force mysql LIKE to be case sensitive?
  57. Postgres Error: More than one row returned by a subquery used as an expression
  58. ERROR 1148: The used command is not allowed with this MySQL version
  59. Comparing Dates in Oracle SQL
  60. MySQL starts with searching issue
  61. Is it possible to GROUP BY multiple columns using MySQL?
  62. Update statement with inner join on Oracle
  63. Best way to test if a row exists in a MySQL table
  64. The used SELECT statements have a different number of columns
  65. MySQL: Can’t create table (errno: 150)
  66. Join vs. sub-query
  67. Alternative to except in MySQL
  68. Oracle: If Table Exists
  69. DATEDIFF function in Oracle
  70. Equivalent of explode() to work with strings in MySQL
  71. How to do a batch insert in MySQL
  72. How to create id with AUTO_INCREMENT on Oracle?
  73. LEFT function in Oracle
  74. Solutions for INSERT OR UPDATE on SQL Server
  75. MySQL – Get row number on select
  76. MySQL error: Unknown column in ‘where clause’
  77. What is the difference between Views and Materialized Views in Oracle?
  78. How to truncate the text returned for a column in a MySQL query
  79. “select * into table” Will it work for inserting data into existing table
  80. Using union and order by clause in mysql
  81. ORA-01735: invalid ALTER TABLE option – Toad
  82. How to execute mulitple statement SQL queries using $wpdb->query?
  83. Size article thumbnails and retrieve them directly from database
  84. wpdb_prepare with multiple or condition
  85. How do I find which articles are missing a featured image in The WordPress database?
  86. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  87. How do I get the posts within a certain year/date(with sql query)?
  88. Create table from array with prepare
  89. Migrating to WordPress Recipe Plugin and Some SQL Issues
  90. Using AND and bracket grouping in SQL not working
  91. SQL query to set posts in bulk based on the post content
  92. WP MultiSite: Can’t select database error after changing to new domain
  93. $wpdb->get_var – What value is returned when zero records are found?
  94. DB prefix not updating
  95. Performing CRUD operations on front end in wordpress
  96. How to create index (sql) to a meta_key?
  97. The function is deprecated; use mysql_real_escape_string() instead
  98. can’t delete a row from post_meta table
  99. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  100. export individual posts to text files or a single csv file

Leave a Comment