Geo Coder mysql Query

Hi,

Are you referring to the code used for a search? The search query is generated dynamically using a function called geocoder_getOptions(), so you can take a look at that function to get an idea of how things work.

If you just need to see an example of what this produces, you can use the 'debugSql' option on the geocoder search example page:

// get records
list($addressRecords, $addressMetaData) = getRecords(array(
'tableName' => $GLOBALS['GEOCODER_SAMPLE_TABLENAME'],
'debugSql' => true,
) + $geoOptions); // geoOptions WILL NOT override the above options

Hope this helps