Why is it not recommended to use the mixture of quoted as well as unquoted values in MySQL IN() function’s list?

Actually, MySQL has different comparison rules for quoted values such as strings and unquoted values such as numbers. On mixing the quoted and unquoted values in IN() function list may lead to the inconsistent result set. For example, we must not write the query with IN() function like below −

Select Salary from employee where ID IN(1,’a’,2,3,’c’)

Instead of this the better way to write the above query is as follows −

Select Salary from employee where ID IN(‘1’,’a’,’2’,’3’,’c’)

George John

Published on 21-Feb-2018 09:53:33

• Related Questions & Answers
• MySQL Quoted table/field names vs unquoted names?
• Why it is better not to create numbers as objects in JavaScript?
• How to concat Values in MySQL Query and to handle Null values as well?
• How to select multiple max values which would be duplicate values as well in MYSQL?
• Why is it not good practice to use date values with two-digits years in MySQL?
• Extract gender values as a string when it is stored in the table as a Boolean in MySQL
• What MySQL returns if the search string is not in the list of strings provided as argument in FIELD() function?
• How can we use MySQL POWER() function with the column’s data values?
• What happens if I will use integer values as arguments of MySQL LOCATE() function?
• How to use ‘as’ operator in C#?
• Though many of the Indian batsmen are match winners then why only MS Dhoni is quoted as the Best finisher?
• What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
• What is AMBUSH Marketing? Why is it known as surprise attack?
• MySQL query to count the dates and fetch repeated dates as well
• Why is Greenland called as island and not a continent?