I'm having problems mounting an sql to my system.
I have a anuencias
table with a status
column. I want to list data where in status contain words "signature", "ready for sending" and "cartorio" but that these data are of a certain period that the user informs.
I have a column called created
where the date and time of each record that I could use to filter the data by period using the between
function is saved.
I tried to do something like this, but the query returns all records.
SELECT * FROM anuencias
WHERE status like '%ASSINATURA%' OR
status like '%PRONTA PRA ENVIO%' OR
status like '%CARTORIO%' OR
created BETWEEN '2017-08-01' AND '2017-08-31'