SQLite Read Column

I have a SQlite Database with an id,name,number.

My problem is that I need a command which gives me the name connected with an AutoComplete function in an editView and in another editView there should stand the correct number related to the name. For example: I have the name rice and the number 50. I want the rice in the first editText and connected to the AutoComplete and the number 50 in another editText.

I am looking up the internet and also some manuals for SQLite for that, but it seems like I am too blind to find the right command. Someone has a suggestion for a tutorial where this is shown or someone has the right command for me to read this information out of my database.

Answers


SELECT number FROM table_id_name_number WHERE name = 'rice';

Need Your Help

How to position images in a slider using js

javascript jquery html css

I am creating a slideshow with 3 images of width 700px and I want to set the image 'left' position of each image from jquery, so that the images slide in, showing the current image and hiding the o...

T-SQL GROUP BY - list instead of agregate function in the result

sql-server tsql group-by

Is there any way to use GROUP BY in T-SQL but get "join-list" as a result instead of agregate function?