Top "Find-in-set" questions

Select Multiple Ids from a table

I want to select some id's based on url string but with my code it displays only the first. If …

mysql sql select in-clause find-in-set

MySQL Join two tables with comma separated values

I have 2 tables as below Notes Table ╔══════════╦═════════════════╗ ║ nid ║ forDepts ║ ╠══════════╬═════════════════╣ ║ 1 ║ 1,2,4 ║ ║ 2 ║ 4,5 ║ ╚══════════╩═════════════════╝ Positions Table ╔══════════╦═════════════════╗ ║ id ║ name ║ ╠══════════╬═════════════════╣ ║ 1 ║ Executive ║ ║ 2 ║ Corp Admin ║ ║ 3 ║ Sales ║ ║ 4 ║ Art ║ ║ 5 ║ Marketing ║ ╚══════════╩═════════════════╝ I …

php mysql left-join group-concat find-in-set

Speed of query using FIND_IN_SET on MySql

i have several problems with my query from a catalogue of products. The query is as follows: SELECT DISTINCT (cc_…

mysql performance find-in-set

Codeginter $this->db->where() function concating "IS NULL" in query automatically when using find_in_set() function

I am writing a query in codeigniter with FIND_IN_SET() function. $this->db->where(FIND_IN_SET(…

codeigniter find-in-set

mysql FIND_IN_SET equivalent to postgresql

select * from folder f,uploads u where u.id=f.folderId and FIND_IN_SET('8', '15,9,13,27') Please …

postgresql equivalent find-in-set

Left Join with Find in set

I have tables as follows : TABLE A +-----+---------------+-------------+ | ID | DNR_DETAIL_ID | DESCRIPTION | +-----+---------------+-------------+ | 1 | 1 | DESC A | +…

mysql join find-in-set