package persistlayer;

import java.sql.Connection;
import java.sql.ResultSet;

public class SearchPersistImpl{

    //global variables
	DbAccessImpl db = new DbAccessImpl();
	Connection con = db.connect();

    public ResultSet getSuggestions(String searchbarContent){
        ResultSet rs;
		String query = "SELECT DISTINCT make FROM cars WHERE make LIKE "+ "%%\"" + searchbarContent + "\"%% LIMIT 1";
		rs = db.retrieve(con, query);
		return rs;
    }//getSuggestions


}//SearchImpl

@@ -322,16 +322,17 @@
 NCT make
+s
  FROM ca
@@ -354,16 +354,12 @@
 IKE 
-%22+ %22%25%25%5C%22
+%5C'%25%25
 %22 + 
@@ -382,12 +382,12 @@
  + %22
-%5C%22
 %25%25
+%5C'
  LIM

Update SearchPersistImpl.java