What is better subquery vs literal on IN clause in mysql

by

It all depends on your initial requirements. If you know the values (here 1,2,3,4) are static, you may hard code them. But if they will change in the future, it is better to use the sub query. Normally subquery is more durable but more resource consuming.

Please elaborate on your requirements, so that we can understand the problem and answer you better.

EDIT 1:

Ok, first of all, i have never seen a EAV model on two table, basically it is done with one table. In you case you will have difficulty searching for the key in the two table when you can combine them in one table. Ideally, you table should be like this : 

CREATE TABLE BOARD
(
   BoardKey INT UNSIGNED,
   Content TEXT,
   Value TEXT
   PRIMARY KEY (BoardKey)
)

Finally, you can do

SELECT * FROM BOARD WHERE Value="SOME"

If the value ‘SOME’ will change in the future, better stick with Subquery. Hope it helped, vote answered if so.

More Related Contents:

  1. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  2. Recreating a query using INNER JOIN? [duplicate]
  3. Getting the SUM() of claps and at the same time counting bookmarks in one query
  4. SQL query return data from multiple tables
  5. Remove duplicate rows in MySQL
  6. quick selection of a random row from a large table in mysql
  7. MySQL SELECT only not null values
  8. Ordering by specific field value first
  9. MySQL DELETE FROM with subquery as condition
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. Subqueries with EXISTS vs IN – MySQL
  12. MySQL/MariaDB – order by inside subquery
  13. How to delete from select in MySQL?
  14. Checking multiple columns for one value
  15. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  16. MySQL INSERT INTO … VALUES and SELECT
  17. MySQL error 1241: Operand should contain 1 column(s)
  18. How to select one row randomly taking into account a weight?
  19. quick selection of a random row from a large table in mysql
  20. Compare only day and month with date field in mysql
  21. Syntax error when using except in a query
  22. SELECT query return 1 row from each group
  23. MySQL INNER JOIN select only one row from second table
  24. MySQL Select Query – Get only first 10 characters of a value
  25. SQL query to check if a name begins and ends with a vowel
  26. How to SELECT by MAX(date)?
  27. The total number of locks exceeds the lock table size
  28. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  29. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  30. Why MySQL is giving error “Not allowed to return a result set from a function”?

Leave a Comment