You can store multiple values in MySQL using:
Multiple Tables: Use a relational schema (e.g., items and tags tables with a foreign key). Best for scalability and queries.

JSON Data Type (MySQL 5.7+): Store tags as JSON (e.g., json_encode(["tag1", "tag2"]) in PHP), then decode with json_decode() and explode(',', ...) if needed. Ideal for flexibility.