SQL/MySQL/ORACLE DBA Learning

Is there any way to say skip in mysql?? Like If my mysql query is Select * from tablename where date between '2023-01-01' and '2023-01-05' Now if i want to skip the second date Is there any command to say pass like python