In a MySQL database, I have two columns of type varchar that brings me records in this format:
["165","184","192","209","242"]
One more example:
Each number in double quotation marks is a record, that is, it is the ID of some student.
I need a select that brings me how many IDs it has per column.
In the case of column curso1
, the result would be 8
.
Is this type of query possible?