PHPmysqlsearchbarinpointofsales

I need your help.

I build a inventory and management stock + invoice. I have a table invoice with columns:

id, customer_name, net_total, paid, due, ordre_date

I have done a page who show all net_total of each day. I want to add searchbar which allows to search the net total of specific day.

I use this query

select  ordre_date as ordre_day, sum(net_total) as privé
from invoice
group by order_day
where order_day like  '%".$search."%'