Error #1064 from MySQL searching database for results near lat/long

Question

I'm trying to run a SQL query to search for a term and a users location. I need help to search my database for locations near a user with the description of 'X'. The users location (lat, long) is drawn when they click 'find' on a form for 'X'.

Individually each query works fine. I can find all with a specific %search_term% using:

 SELECT * FROM  `table_name` WHERE  `column_name` LIKE '%search_term%'

and also find all the locations from the distant of the user using:

  SELECT *, (
  3959 * acos (
  cos ( radians($lat) )
  * cos( radians( lat ) )
  * cos( radians( lng ) - radians($long) )
  + sin ( radians($lat) )
  * sin( radians( lat ) )
  )
  ) AS distance
  FROM locations
  HAVING distance < 50
  ORDER BY distance
  LIMIT 0 , 20;

but together I receive an error #1064.

This is the query:

  SELECT * FROM  `table_name` WHERE  `column_name` LIKE '%search_term%' AND 
  *, (
  3959 * acos (
  cos ( radians($lat) )
  * cos( radians( lat ) )
  * cos( radians( lng ) - radians($long) )
  + sin ( radians($lat) )
  * sin( radians( lat ) )
  )
  ) AS distance
  FROM locations
  HAVING distance < 50
  ORDER BY distance
  LIMIT 0 , 20;

Answer 1

Error 1064 means syntax error. You are putting "AS distance" at wrong place. Try this:

SELECT *, (3959 * acos(cos (radians($lat))*cos(radians(lat))*cos(radians(lng) - radians($long))+sin (radians($lat))*sin( radians( lat ) )  )  ) AS distance FROM  `table_name` WHERE `column_name` LIKE '%search_term%' HAVING distance < 50 ORDER BY distance  LIMIT 0 , 20;