How to write a SQL query correctly? Working with Like?

Question

Laravel

Get a list of books written by 3 or more co-authors, indicating the number of authors (no names)

SELECT * FROM books WHERE authorId LIKE '% %, % %, % %'

First Name Last Name, First Name Last Name, First Name Last Name. in one column.
For example, Stanley Lippman, Josy Lajoye, Barbara Moo.
In general, how to make it so that there are three authors (and not three like mine) and the number of authors is displayed?

Answer 1

select
     (char_length(authorId) - char_length(replace(authorId,',','')) + 1) as author_cnt
    ,b.*
  from books b
  where (char_length(authorId) - char_length(replace(authorId,',','')) + 1) >= 3