need select query

umair mohsin

11y1.2k.NET

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.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saumitr Sharma11y ago
SELECT column name
FROM table_name
WHERE column name LIKE 'A%'
try this it will display the record that start with latter 'A'
0
Jignesh Trivedi11y ago
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.
0
Joginder Banger11y ago
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
0
umair mohsin11y ago
what is the difference between 2nd one and the third one can you please elaborate with an example
0
umair mohsin11y ago
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.
0
Joginder Banger11y ago
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.
0
Khargesh Rajput11y ago
use like clause

select * from student_table where name like "''+@name+'%'"
0
Priya Avanigadda11y ago
Hii, Do u want to display the names to start with "s" right??
0