Filter result from a single name in a SET with multiple entries

Asked Jan 20 '22 at 16:23

Active Jan 20 '22 at 16:23

Viewed 10 times

I have a column of SET type made up of creators of comic books.

In PHP, I do a query to get all the comics with a single creator.

If I do a query using WHERE creator = "John Byrne", I can see every entry where John Byrne is the only and single item, but as soon as I have more than one item in my SET, nothing appears...

Here's an example of the query:

$sql = "SELECT * FROM comic_list AS A LEFT JOIN title_list AS B ON A.title = B.title_ID WHERE A.creators='John Byrne'";

asked Jan 20 '22 at 16:23

Mehdi Bouhalassa

1

Use `FIND_IN_SET()`. – Barmar Jan 20 '22 at 16:26
@Barmar I have this query: ```$sql = "SELECT * FROM comic_list AS A LEFT JOIN title_list AS B ON A.title = B.title_ID WHERE FIND_IN_SET ('Chip Zdarsky')";``` I get this error: ``` Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool ``` – Mehdi Bouhalassa Jan 20 '22 at 17:10
You didn't say what column to search in your call to `FIND_IN_SET()`. – Barmar Jan 20 '22 at 17:12
1

`WHERE FIND_IN_SET('Chip Zdarsky', A.creators)` – Barmar Jan 20 '22 at 17:12
@Barmar Fantastic, it worked! Thanks again for your time and patience, it's greatly appreciated. – Mehdi Bouhalassa Jan 20 '22 at 17:16

Filter result from a single name in a SET with multiple entries

0 Answers0