how to restrict like characters upto 3 in mysql statement?

Question

0.00/5 (No votes)

See more:

C#

string query = "SELECT medicine_name FROM medicines WHERE medicine_name like '" + clientName + "%'";

the above is the query i am using,but my problem is i want to show the user the related dats only after they type 3 or 4 character..but this statement will simply show even if they type single character..so pls help me,i tried in google i didnt find any solution...i am really looking for your solutions

thanks
in advance
velu

Posted 25-Sep-11 20:31pm

Iam Velu

Updated 25-Sep-11 21:22pm

walterhevedeich

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

P.Salini · Answer 1 · 2011-09-25T20:36:00

Solution 1

Check the length of input in button click

that means in button click event
write as follows

if(txtinput.text.length>2)
{
  //code to get details
}
else
{
   //alert a message that you need to give minimum of 3 letters

}

Posted 25-Sep-11 20:36pm

P.Salini

v2

Comments

Iam Velu 26-Sep-11 2:37am

NO i want to do it in query itself..not like programatically..is there any way for doing this?is tat possible?

P.Salini 26-Sep-11 2:56am

if user did not enter 3 letters then what you want to display

P.Salini 26-Sep-11 3:02am

Up to my knowledge i dont think its possible.
If possible i wish to know the answer

Arun Kumar K S 26-Sep-11 3:21am

You r rt...,my up vote to you

Zasky · Answer 2 · 2011-09-25T22:10:00

I think the first solution gives the most flexibility, but if you really want it in SQL you could just add a string length condition. The following statement will only return results when clientName contains more than 3 characters. Note that the LENGTH function is dependent on the DB you are using.

SQL

string query = "SELECT medicine_name FROM medicines WHERE medicine_name like '" + clientName + "%' AND LENGTH('" + clientName + "') < 4)";

Jephunneh Malazarte · Answer 3 · 2011-09-25T22:04:00

Solution 3

you may wanna try this one out but this is not the effecient code:

Declare @myValue as varchar(100);
Set @myValue = 'mySearch';	--replace this one the value you wanna search

IF Len(@myValue) >= 3
Begin
	Select * from table where column like @myValue + '%';
End

Else
Begin
	Select ''
End

Posted 25-Sep-11 22:04pm

Jephunneh Malazarte