id=186</br>SELECT bus_id,bus_trip,trip_date  FROM `trip_log` WHERE BUS_TRIP LIKE concat ('%', LEFT(UPPER('Μεσολογγίου'),3), '%') AND trip_date >= CURRENT_DATE() ORDER BY `trip_log`.`date_in` DESC</br>