How to use having with or condition in mysql?

Question

I have two similler queries with same table name which are working fine individually. But I want to merge them with condition ((city_id = 1 and country_id = 1) or distance < "20")

First query

select id , lat , long , city_id , country_id 
from element_table
where city_id = 1 and country_id = 1 and id < 20

Second query Here I am using search with lat lon

 select id , lat , long , city_id , country_id ,
 my_distance_calculationformula_with_lat_long as distance  
 from element_table where id < 20 having distance = "20"

Take a look at http://stackoverflow.com/questions/1316600/using-or-between-having-and-where-clause-in-mysql — d3v_1, Sep 08 '16 at 12:03

ScaisEdge · Accepted Answer · 2016-09-08T12:41:17.243

you can use where and having

select id , lat , long , city_id , country_id ,
my_distance_calculationformula_with_lat_long as distance  
from element_table
where city_id = 1 and country_id = 1 and id < 20 
having distance = 20

in you case (your comment) Then you should not use an alias and perform only the where

select id , lat , long , city_id , country_id ,
my_distance_calculationformula_with_lat_long as distance  
from element_table
where city_id = 1 and country_id = 1 and id < 20 
or   my_distance_calculationformula_with_lat_long < 20

(and if your my_distance_calculationformula_with_lat_long is a long sql code . you should repeat the code for not using alias ..column alias in not allowed in where)

i want to make condition like this ((city_id = 1 and country_id = 1) or distance < "20") — Vipul sharma, Sep 08 '16 at 12:32

How to use having with or condition in mysql?

1 Answers1