Mysql Join Two tables on keys

by

First of all, you should normalise your data structure an have a connection table between keys2 and education table.

To make the join work with the current data structure, use mysql’s find_in_set() function:

SELECT *
FROM education AS a
JOIN keys2 AS b on find_in_set(b.`List Idsubjek`,a.`List Idsubjek`)>0 
WHERE b.`List Idsubjek` IN (52, 54, 55, 67)
AND `studentid` = '$id'

More Related Contents:

  1. how to generate report for attendance system
  2. MySQL pivot table query with dynamic columns
  3. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  4. Finding duplicate values in MySQL
  5. Error installing mysql2: Failed to build gem native extension
  6. How to debug Lock wait timeout exceeded on MySQL?
  7. CROSS/OUTER APPLY in MySQL
  8. How to extract two consecutive digits from a text field in MySQL?
  9. Connect By Prior Equivalent for MySQL
  10. How to send email from MySQL 5.1
  11. MySQL skip first 10 results
  12. Import Data from Excel Spreadsheet or CVS into MySQL
  13. MySQL vs MongoDB 1000 reads
  14. How to convert all tables from MyISAM into InnoDB?
  15. How can I get rid of these comments in a MySQL dump?
  16. How to create relationships in MySQL
  17. MySQL error 1436: Thread stack overrun, with simple query
  18. int(11) vs. int(anything else)
  19. ALTER TABLE to add a composite primary key
  20. MySQL Removing Some Foreign keys
  21. node.js + mysql connection pooling
  22. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  23. MySQL – How to select data by string length
  24. SQL Order By Count
  25. What resources exist for Database performance-tuning? [closed]
  26. dump all mysql tables into separate files automatically?
  27. How to select the first row for each group in MySQL?
  28. MySQL OPTIMIZE all tables?
  29. What’s mysql’s “BETWEEN” performance over..?
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment