sql - Query for searching the name alphabetically

Question

I have used the LIKE condition, but it required me to enter the full name into the database to find the name.

if (searchby.equals("Name"))
{
    try
    {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        System.out.println("
 Driver loaded");
        Connection con=DriverManager.getConnection("jdbc:odbc:wanisamajDB");
        Statement stmt=con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT Name FROM FAMILYcensus WHERE Name LIKE '"+ tfsearch.getText()+"'");
        //  ResultSet rs = stmt.executeQuery("SELECT Name FROM FAMILYcensus WHERE Name LIKE );
        System.out.println("Hi");

        rs.next();
        String names = rs.getString("NAME");
        System.out.println("NAME: " + names );

        JOptionPane.showMessageDialog(null, "RECORD FOUND");

        tasearch.setText(names);
    }
    catch (Exception e)
    {
        System.out.println("EXCEPTION " + e);
    }

Answer 1

WhiteFang34 also said you need to iterate. But also you need to change to WHERE clause:

"SELECT * FROM FAMILYcensus WHERE Name > '"+ tfsearch.getText()+"' ORDER BY Name ASC LIMIT "+MAXRESULTS;

Note that limiting the number of results is a good idea here.