hello people, I would like to create an index so that the query on here can
use it,
SELECT
*FROM
table_nameWHERE (code_id = 1
OR code_id = 2
OR (code_id = 3
AND created_date < now()))
LIMIT 1;
please advise me on how I should create index. I created index on code_id
but it's not being used