Knowledge Walls
John Peter
Pune, Maharashtra, India
IN() with multiple column values in Smart Tricks of MySQL
3464 Views
How to compare combined multiple column values with IN() function
SELECT
   book_name,book_type
FROM
   books
WHERE
   concat(book_name,"-",book_type) IN (SELECT concat(book_name,"-",book_type) FROM books_copy);
  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