Find string in SQL column

Question

I have the next code(found here at stack overflow):

 string [] arr = {"One","Two","Three"};
   var target = "One";
   var results = Array.FindAll(arr, s => s.Equals(target));

This code good for search string on array... i need to find string in sql column.

Let's say i have table ("Names"), and i want to find "Jhon".. how can i do that?

I don't need connectionstring or the whole method, that's i know to do, but i can't think on method to search specific string at sql table.
Will be great to see version of search: "Jh" and it will find "Jhon" if is there...

Bob Vale · Accepted Answer · 2012-08-21 22:40:51Z

2

Well to avoid sql injection if target is user provided

string connectionString= ...
string target="jh";

using (var conn=new SqlConnection(connectionString)) {
conn.Open();
  using (var cmd=conn.CreateCommand()) {
    cmd.CommandText="select Name from Names where Name like '%'+@value+'%'";
    cmd.Parameters.AddWithValue("@value",target);

    using (var reader=cmd.ExecuteReader()) {
        while (reader.Read()) { 
            Console.WriteLine(reader[0]);
        }
    }

  }
}

Use like '%'+@value+'%' for contains
Use like @value+'%' for starts with
Use like '%'+@value for ends with

answered Aug 21, 2012 at 22:40

Bob Vale

18.5k1 gold badge44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Schmelter · Accepted Answer · 2012-08-21 22:23:57Z

2

SELECT NAME
FROM NAMES
WHERE NAME='Jhon'

Is this what you're looking for?

If only a part of it needs to match:

...
WHERE NAME LIKE 'Jh%'

LIKE

answered Aug 21, 2012 at 22:23

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

1 Comment

Duncan Howe Over a year ago

Probably a like clause would be more useful - SELECT Name FROM Names WHERE Name like '%Jhon%'

Collectives™ on Stack Overflow

Find string in SQL column

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related