Some times if we want to update a table or query a table for multiple values in a single column we have to run our simple sql query multiple times. Suppose if you want to get an element value in a column of a table you normally run a select command as shown below.

	SELECT * FROM `table1` where column='abc'

or

	SELECT * FROM `table1` where column is 'abc'

But if we want to select multiple values of a given column the above statement will not work properly. We have to modify to accomplish that. We can use in SQL keyword to achive this. Below example shows on how to select multiple values in a given column.

	SELECT * FROM `table1` where column in ( 'element1', 'element2', 'element3')

We can include as many element you want in those braces.

Post Views: 29,358
The following two tabs change content below.
My Twitter profileMy Facebook profileMy Google+ profileMy YouTube channel

Surendra Anne

Mr Surendra Anne is from Vijayawada, Andhra Pradesh, India. He is a Linux/Open source supporter who believes in Hard work, A down to earth person, Likes to share knowledge with others, Loves dogs, Likes photography. He works as Devops Engineer with Taggle systems, an IOT automatic water metering company, Sydney . You can contact him at surendra (@) linuxnix dot com.