Rectangle 27 0

PHPMYSQL: What should the best way to record any undefined optionals data from the user and optimized to search?

Definitively 3). Storing a serialized array means being dependend on a language (php, json etc), and selecting via sql is impossible. 2) ist bad, because of several reasons; mainly, you are less flexible in extending and selecting. Create a meta table like 3), this is an established approach.

Update: 3) must be improved a bit: Create a table like this: