SQL query of multiple values in one cell

by

Use FIND_IN_SET to search for something in a comma-delimited list.

SELECT i.MemberID, i.MemberName, GROUP_CONCAT(c.Course) AS CoursesInterested
FROM CourseInterests AS i
JOIN Course AS c ON FIND_IN_SET(c.CourseId, i.CoursesInterested)

However, it would be better to create a relation table instead of storing the courses in a single column. This type of join cannot be optimized using an index, so it will be expensive for a large table.

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. MySQL offset infinite rows
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. MySQL Group by SUM
  14. Set NOW() as Default Value for datetime datatype?
  15. In SQL, how to select the top 2 rows for each group
  16. Mysql query to dynamically convert rows to columns on the basis of two columns
  17. SQL DELETE with JOIN another table for WHERE condition
  18. mysql trigger stored trigger is already used by statement which invoked stored trigger
  19. How to skip certain database tables with mysqldump?
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. How to set a MySQL row to READ-ONLY?
  22. How to create dummy variable columns for thousands of categories in Google BigQuery?
  23. Mysql: Order by like?
  24. Most efficient way to store IP Address in MySQL [duplicate]
  25. Getting first day of the week in MySql using Week No
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. Execute INSERT if table is empty?
  28. Mysql How do you create a clustered index?
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment