Knowledge Walls
John Peter
Pune, Maharashtra, India
Comparing multiple columns with single value
1725 Views
Using IN() in smart way
SELECT * FROM books WHERE book_name = "CPP" OR alias_book_name = "JAVA" OR actual_book_name = ".NET";

instead of

SELECT * FROM books WHERE "CPP" IN (book_name, alias_book_name, actual_book_name);
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details