title: PHP MySQL search script - match only some letters
body: <p>have search function in my website. Problem is:
  if I write word Litmanova it doesn't find anything because in mysql are words litmanovej, litman etc. </p>
  
  <p>Is there any way to find for example result litmanovej if I will put litmanova in search input?
  Thank you.</p>
  
  <pre><code>function search() {
    echo "&lt;div class='col-md-12' style='margin-top:20px;'&gt;";
    echo "&lt;div id='custom-search-input'&gt;";
    echo "&lt;form action='vyhladavanie' method='GET'&gt;";
    echo "&lt;div class='input-group col-md-12'&gt;";
    echo "&lt;input type='text' class='form-control input-lg' name='query' placeholder='Napíšte slovo, ktoré hľadáte...' /&gt;";
    echo "&lt;span class='input-group-btn'&gt;";
    echo "&lt;button class='btn btn-info btn-lg' type='submit' style='background:#cf585b;border:1px #cf585b solid;'&gt;";
    echo "&lt;i class='glyphicon glyphicon-search'&gt;&lt;/i&gt;";
    echo "&lt;/button&gt;";
    echo "&lt;/span&gt;";
    echo "&lt;/div&gt;";
    echo "&lt;/form&gt;";
    echo "&lt;/div&gt;";
    echo "&lt;/div&gt;";
  }
  
  
  function showVideoResults() {
    global $conn;
    $query = $_GET['query'];
    $query = "SELECT * FROM videos WHERE video_title LIKE '%".$query."%' OR video_description LIKE '%".$query."%' ORDER by video_date DESC";
    $result = mysqli_query($conn, $query);
  
    if (!$result) {
      die("Problém" . mysqli_error($conn));
    }
  
    while ($row = mysqli_fetch_array($result)) {
        $video_id = $row['video_id'];
        $video_title = $row['video_title'];
        $video_date = $row['video_date'];
        $video_description = $row['video_description'];
        $video_link = $row['video_link'];
        $video_category = $row['video_category'];
        $video_url = $row['video_url'];
  
        echo "&lt;div class='col-md-4'&gt;";
        echo "&lt;a href='video/$video_id-$video_url'&gt;";
        echo "&lt;h3 class='meta_title'&gt;$video_title&lt;/h3&gt;&lt;/a&gt;";
  
        echo "&lt;/div&gt;";
    }
  }
  </code></pre>