How to show only the records exactly the same as those typed?

Question

I have this code that shows all records as long as the initial number or letter is the same, but I wanted to show only the records that are exactly the same as those typed in the search field, or else show at most 5 records.

<?php 
include 'conn.php';

$letter = $_GET["letter"];


$sql = "SELECT id,palavra from interpretacao_cpp where pronta != 0 AND palavra LIKE '".$letter."%'" ;

$result = $conn->query($sql);


$sql2 = "SELECT DISTINCT(SUBSTR(`palavra`, 1, 1)) As abc from interpretacao_cpp where pronta != 0 ORDER BY abc" ;

$result2 = $conn->query($sql2);

?>

Answer 1

Taking as an example one of your queries:

$sql = "SELECT id,palavra from interpretacao_cpp where pronta != 0 AND palavra LIKE '".$letter."%'" ;

Placing limit of 5 results, using the limit:

$sql = "SELECT id,palavra from interpretacao_cpp where pronta != 0 AND palavra LIKE '".$letter."%' limit 5" ;

Or exactly like the term typed:

$sql = "SELECT id,palavra from interpretacao_cpp where pronta != 0 AND palavra = '".$letter."'" ;

In case you don’t know, I advise you to take a look at sql Injection.

Answer 2

The correct code to answer the question is as follows, limiting the number of records shown and sorting them by one of the table fields:

$sql = "SELECT id,word from interpretacao_cpp Where pronto != 0 AND word LIKE '". $Letter." %' ORDER BY id asc limit 5" ;