PHPackages                             wuhen/mysql-to-es - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. wuhen/mysql-to-es

ActiveLibrary[Database & ORM](/categories/database)

wuhen/mysql-to-es
=================

mysql sql to elasticsearch,mysql语句转换ES语句查询

v1.0(5y ago)113MITPHPPHP >=5.3

Since Jul 14Pushed 5y agoCompare

[ Source](https://github.com/guoqing1988/mysql-to-es)[ Packagist](https://packagist.org/packages/wuhen/mysql-to-es)[ RSS](/packages/wuhen-mysql-to-es/feed)WikiDiscussions master Synced today

READMEChangelog (1)DependenciesVersions (3)Used By (0)

EsParser
========

[](#esparser)

php的操作类库，通过写sql来转化dsl来查询elasticsearch

### composer使用

[](#composer使用)

```
{
    "require": {
        "wuhen/mysql-to-es": "dev-master"
    }
}
composer install
require __DIR__.'/vendor/autoload.php';
//$sql = 'select * from alp_dish_sales_saas where sid in(994,290) limit 1,10';
//$sql='update alp_dish_sales_saas set mid=3  where adsid=15125110';
//$sql='delete from alp_dish_sales_saas where adsid=15546509';
//$sql="select *,concat_ws('_',category_name.keyword,dish_name.keyword,sku_name.keyword) as dfg from alp_dish_sales_saas where sale_date>'2017-01-01' and sale_date'2017-01-01' and sale_date