I want to query against one user_id in the string. eg user_id:2002+AND+created:[${from}+TO+${until}]+data:"more"
So all of the records with a 2002 in user_id need to be returned and only those records. If this can only be guaranteed by having user_id be an integer, then that is fine, but I would like to reduce the growth of our table. *Row X* > > column1: "data here" > column2: "more data here" > ... > user_id: 2002 > > *Row Y* > > column1: "data here" > column2: "more data here" > ... > user_id: 45 > > *Row Z* > > column1: "data here" > column2: "more data here" > ... > user_id: 45664 > > So what I plan on doing before inserting into mysql, which is where solr > pulls the data from, is shrinking similar datasets into one row: > > *Single Row XYZ* > > column1: "data here" > column2: "more data here" > ... > user_id: "2002 45 45664" >