need select query

Question

i need select query for my data base. suppose i have 100 records in my database and i want to search records with a or b. or any any other character.selection is done by textboxes i am writing this code select * from student_table where name ="@name" cmd.parameters.addwithvalue("@name",txtname.text); now if i press s then records starts with s sholud display but not those records in which s is not the first word e.g. sahil siddharth siddhu rajesh suraj bhansali rishab,james,kailash suresh i need a query to display records like sahil,siddhu,suraj ,siddharth,suresh not the other ones.

Saumitr Sharma · Answer

SELECT column name FROM table_name WHERE column name LIKE 'A%' try this it will display the record that start with latter 'A'

Jignesh Trivedi · Answer

Hi,

As explain above you can use LIKE operator....

Please refer below link to know more about LIKE
http://www.techonthenet.com/sql/like.php
http://beginner-sql-tutorial.com/sql-like-in-operators.htm
https://msdn.microsoft.com/en-us/library/ms179859.aspx

hope this will help you.

Joginder Banger · Answer

suppose in table have three row in name column.

aadity
shail
jjkka

your query value is a

select * from tableName where columnName like "''+your query value+'%'" -- this query working only start with your query value.
output is aadity

select * from tablename where columnName like "'%'+@name+''" -- this query working only end with your query value.
output is jikka

select * from tablename where columnName like "'%'+@name+'%'" -- this query working match a your query value complete value.
output is
aadity
shail
jjkka

umair mohsin · Answer

what is the difference between 2nd one and the third one can you please elaborate with an example

umair mohsin · Answer

yes this is what i want. but if s comes with other names those names should not display.

text boxes are there to find records it is not specifically the word starting with s. i need the query to display record as i directed to textboxes.

e.g: if a comes in aaditya and a also comes in sahil then, aaditya should display but not sahil.

Joginder Banger · Answer

Hi umair,
your query is wrong because you want start with S but you are assign complete value. if you want records only start with S just changed your query like

select * from tableName where columnName like "''+your query value+'%'" -- this query working only start with your query value.

select * from tablename where columnName like "'%'+@name+''" -- this query working only end with your query value.

select * from tablename where columnName like "'%'+@name+'%'" -- this query working match a your query value complete value.

Khargesh Rajput · Answer

use like clause select * from student_table where name like "''+@name+'%'"

Priya Avanigadda · Answer

Hii, Do u want to display the names to start with "s" right??

need select query

Answers (8)