Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user_id | first_name | last_name
- 1 | John | Smith
- 2 | Mary | Jones
- 3 | Sang He | Lau
- // here is a sample of the code I currently have to do a user search
- public List<string> getResults(string autocompleteQuery) {
- string[] tokens = autocompleteQuery.Split(' ');
- // token[0] = first name parameter (@firstName)
- // token[1] = last name parameter (@lastName)
- // code here executes the following query:
- // SELECT * FROM [user] WHERE first_name = @firstName AND last_name = @lastName
- }
- SELECT * FROM [user]
- WHERE
- first_name + last_name LIKE '%' + token[0] + '%'
- AND
- first_name + last_name LIKE '%' + token[1] + '%'
- AND
- first_name + last_name LIKE '%' + token[2] + '%'
- ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement