CODEWITHSUNDEEP
phpmysqlfilteringbetweensql-like
Yasin Yusuf
Yasin Yusuf

Reputation: 85

filter table mysql using multiple colums also between

how to join BETWEEN statement and AND statement using multiple category?

SELECT * FROM quick_inquiry WHERE inquiry_time BETWEEN '$start' AND  '$end' AND
  inquiry_language LIKE '%$language%' AND
  service_country LIKE '%$country%' AND
  category LIKE '%$category%' AND
  replied LIKE '%$replied%'

Upvotes: 2

Views: 66

Answers (1)

sqluser
sqluser

Reputation: 5672

Try this:

SELECT * FROM quick_inquiry
WHERE (inquiry_time BETWEEN '$start' AND '$end')
AND inquiry_language LIKE '%$language%'
AND service_country LIKE '%$country%'
AND category LIKE '%$category%'
AND replied LIKE '%$replied%'

Also you can use >= and <=

SELECT * FROM quick_inquiry
WHERE inquiry_time >= '$start'
AND inquiry_time <= '$end'
AND inquiry_language LIKE '%$language%'
AND service_country LIKE '%$country%'
AND category LIKE '%$category%'
AND replied LIKE '%$replied%'

Upvotes: 1

Related Questions