where is the List of field type selector

Hello everybody, someone know in what table of the database are located  the lists used when the type of field is selector. Because, the value saved on the table profiles is a number on some cases, for example, state field is type selector and the values are from a list, and when I make a query on the database for the table profiles, the value for field state is a number, but I need the text like Florida, etc

Thanks in advance.

hello,

You need to execute another query with the value of your query which return that number. like

"SELECT 'state_name' FROM `lists_table_name' WHERE ID = $yournumberfromprofile"

Hope you understand it...:)

Hi, thanks for answer my question, but I found the table, this is 

sys_pre_values.

not sure about your table structure through but you just need to make a simple query to select the name from your name column whatever it is you can find it by looking in that table and just add the "WHERE" clause and put the column name of your column containing the ID probably and value will be the variable from your first query. 

If you are still not sure what to do just post a screenshot of your table here.

 Thanks, But I solved my problem with the sys_pre_values table :D