Definitely not a text
field, but a varchar
— perhaps. I wouldn’t recommend parsing the results and storing them in individual columns unless you want to take advantage of that data in database sense — statistics etc.
If you never see yourself asking “What is the average volume that users use?” then don’t bother parsing it.
To figure out how to store this data ask yourself “How will i use it later?” If you will obtain the array and need to utilize it with PHP you can use serialize function. If you will use the values in JavaScript then JSON encoding will probably be best for you (plus many languages know how to decode it)
Good luck!
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How to use mysqli_query() in PHP?
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- MySQL Error “Operand should contain 1 column”
- How to use MySQL DECIMAL?
- MySQL ERROR 1290 (HY000) –secure-file-priv option
- MySQL server startup error ‘The server quit without updating PID file’
- What does SQL Select symbol || mean?
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
- Duplicating a MySQL table, indices, and data
- mysql Foreign key constraint is incorrectly formed error
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- SELECT * FROM multiple tables. MySQL
- mysql: SOURCE error 2?
- java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
- How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
- MySQL foreach loop
- How to find MySQL process list and to kill those processes?
- How to update a record using sequelize for node?
- Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
- MySQL date format DD/MM/YYYY select query?
- MySQL Server on MAMP-Windows Will Not Start
- SQL statement not working – “Operand type clash: date is incompatible with int’
- How can I output MySQL query results in CSV format?
- MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
- Error: select command denied to user ‘
‘@’ ‘ for table ‘ ‘ - #1214 – The used table type doesn’t support FULLTEXT indexes
- importing a CSV into phpmyadmin
- How can I rebuild indexes and update stats in MySQL innoDB?
- MySQL Error 1215: Cannot add foreign key constraint
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- How to use the keyword ‘references’ in MySQL?
- select * from table where column = something or, when unavailable, column = something else
- Differences between utf8 and latin1
- There can be only one auto column
- MySQL – UPDATE query with LIMIT
- What are the recommended database permissions for WordPress?
- What’s a good strategy for planning WordPress DB growth?
- How can I find the source of slow queries in WordPress?
- $wpdb and MySQL Create Trigger
- how to refresh wordpress permalink settings? (without admin panel)
- wpdb->prepare function remove single quote for %s in SQL statment
- Programmatically changing role information; editing role name and deleting
- Fulltext search in posts sorted by relevancy
- Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
- How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
- How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
- How can I make wordpress suppress mysql errors?
- How to bulk delete all WordPress subscribers?
- Error while importing database
- Changing Table Prefix for an Existing WordPresss Site
- Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
- Mysql SELECT posts
- Connect another DB and fetch records from some tables
- Can I restart MySQL engine when WordPress website is live?
- Error: MySQL shutdown unexpectedly [closed]
- Why my wordpress loopback traffic while socket is setup?
- How to add a private user page populated from sql?
- Update or insert meta key value – On Duplicate key update
- Connect to MySQL using Windows Authentication
- Defining the same price to all WooCommerce Products
- Database Structure on Different Servers
- SQL syntax error. However, it works normally at phpmyadmin
- How to get INSERT errors from $wpdb?
- How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
- string literals in query
- Export Yoast Keywords from MySQL/phpMyAdmin
- Same database; different WordPress
- Create pages from MySQL database
- How to insert dash (-) into database using wpdb and new_to_publish hook?
- MySQL: How to change url in posts from xxx.com to yyy.org?
- How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
- Exporting completed webiste for another server
- Upgrade DB Loop – WordPress DB Version Conflict
- WordPress & MySQL , problem with use many array in meta_query
- Button writing to MYSQL database
- mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
- MySQL ‘duplicate entry’ error
- Find locations of all featured images of draft posts via SQL
- WordPress Dutch characters encoding problem
- How to show result of sql query in a page?
- Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
- How do I insert content of various MySQL fields in post?
- How to change link in all posts?
- Select latest 2 articles, but only from given category
- CONCAT_WS in custom sql query
- Query does not filter duplicate _sku numbers
- Ordering topics by most replies in X days using MYSQL statement
- MySQL Select within WP Page template
- wp_postmeta – lot of meta fields
- Running WordPress from MySQL Cluster with HAPRoxy
- Delete posts with word count less than x number of words
- MySQL: get post_tag items that are tags (not SEO keywords)
- $wpdb->get_var returns 0
- cannot log in to the mysql server (wamp and wordpress)
- SQL command to export post_content from wp_posts using phpMyAdmin
- InnoDB: Error: log file ./ib_logfile0 is of different size
- Postgres equivalent to MySQL’s \G?