5

i have this part of an sql select:

where `zipCode` between "40000" and "42000" OR `zipCode` between "50000" and "51000" OR `zipCode` between "53000" and "60000" AND plan = "sell" AND created_at > '2017-01-01' AND clone_id is not null

I'm getting the correct range of the zipCode back. But the condition with "plan" "ceated_at" and "clone_id" is not working.

Improve this question
1
  • Can u provide a data sample, with the expected output and input data you have? Commented Mar 1, 2017 at 10:24

2 Answers 2

Reset to default
8 
Try below query : where ( `zipCode` between "40000" and "42000" OR `zipCode` between "50000" and "51000" OR `zipCode` between "53000" and "60000" ) AND plan = "sell" AND created_at > '2017-01-01' AND clone_id is not null
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

Try this worked for me:

delete from table_name where column_name between '2018-06-01 09:00:00' and '2018-10-01 18:00:00';
Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.