Hey guys, I'd like to know typically to handle arr...

# server

[Poohrang]

Hey guys,
I'd like to know typically to handle array data (not static) in SQL Database.
In my case, I have a server using Ktor with Exposed framework(Maria DB).

When client sends the filtered array to Server, the Server has to store array on variable or SQL database.
The length of array may vary depending on filter (min:10 max:100).

These values of array eventually are used for WHERE clause of SELECT query.
It is expected that it can be easily used in the WHERE clause by importing it as an ArrayList type.

I have an idea that to make column as String and then contains deliemter like ","
Is it correct way?

Could you please let me know what's the best way to handle array data for database?

Thanks