> For the complete documentation index, see [llms.txt](https://kants.gitbook.io/xeant/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kants.gitbook.io/xeant/mysql/untitled.md).

# 확장변수값  2개 비교

{% hint style="info" %}
 SELECT a.document\_srl FROM (allmydreamcar.rx\_document\_extra\_vars as a LEFT JOIN allmydreamcar.rx\_document\_extra\_vars as b ON a.document\_srl = b.document\_srl) Where a.value=$args->user\_phone and b.value=$args->car\_number"
{% endhint %}

{% code title="controller.php" %}

```php
$oDB = &DB::getInstance();

$query = $oDB->_query("SELECT a.document_srl FROM (allmydreamcar.rx_document_extra_vars as a LEFT JOIN allmydreamcar.rx_document_extra_vars as b ON a.document_srl = b.document_srl) Where a.value=$args->user_phone and b.value=$args->car_number");

$result = $oDB->_fetch($query);
```

{% endcode %}