Join two tables with comma separated values

by 
SELECT  a.nid,
        GROUP_CONCAT(b.name ORDER BY b.id) DepartmentName
FROM    Notes a
        INNER JOIN Positions b
            ON FIND_IN_SET(b.id, a.forDepts) > 0
GROUP   BY a.nid

More Related Contents:

  1. MySQL Join two tables with comma separated values
  2. Laravel – only a zero is saved to the database
  3. storing user_id in session variable
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. Convert from MySQL datetime to another format with PHP
  6. MySQL vs MySQLi when using PHP [closed]
  7. How do I set ORDER BY params using prepared PDO statement?
  8. Passing an array to a query using a WHERE clause
  9. How can I store and retrieve images from a MySQL database using PHP?
  10. PHP/MySQL Insert null values
  11. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  12. Laravel: PDOException: could not find driver
  13. Can you add an if statement in ORDER BY?
  14. PDO Connection Test
  15. Grouping WHERE clauses in Codeigniter
  16. MySQL (or PHP?) group results by field data
  17. SELECT COUNT() vs mysql_num_rows();
  18. Store procedures in phpMyAdmin
  19. Check if a row exists using old mysql_* API
  20. Unique IPs in a voting system
  21. MySQL get a random value between two values
  22. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  23. php password_verify() hash and pass won’t match
  24. MySQL query using an array [duplicate]
  25. PHP mySQL – Insert new record into table with auto-increment on primary key
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment