Join with RLIKE

diego.giovany · April 24, 2015, 5:21pm

Hi everyone,

I’m new on Yii2, I’ve created CRUD with Gii, but have no luky trying to use the query below:

SELECT cdr.*, cdr_lastdata_alias.alias as lastalias FROM cdr

LEFT JOIN cdr_lastdata_alias ON cdr.lastdata RLIKE cdr_lastdata_alias.expr LIMIT 90

Can someone help-me with this?

rupsk1607 · April 25, 2015, 7:11am

use query builder

github.com

yiisoft/yii2/blob/master/docs/guide/db-query-builder.md

Query Builder
=============

Built on top of [Database Access Objects](db-dao.md), query builder allows you to construct a SQL query
in a programmatic and DBMS-agnostic way. Compared to writing raw SQL statements, using query builder will help you write 
more readable SQL-related code and generate more secure SQL statements.  

Using query builder usually involves two steps:

1. Build a [[yii\db\Query]] object to represent different parts (e.g. `SELECT`, `FROM`) of a SELECT SQL statement.
2. Execute a query method (e.g. `all()`) of [[yii\db\Query]] to retrieve data from the database.

The following code shows a typical way of using query builder:

```php
$rows = (new \yii\db\Query())
    ->select(['id', 'email'])
    ->from('user')
    ->where(['last_name' => 'Smith'])
    ->limit(10)

This file has been truncated. show original

shiyang · April 26, 2015, 12:06am

have a try




$query = new \yii\db\Query;

$result = $query->select('cdr.*, cdr_lastdata_alias.alias as lastalias')

            ->from('cdr')

            ->join('LEFT JOIN', 'cdr_lastdata_alias', 'cdr.lastdata RLIKE cdr_lastdata_alias.expr')

            ->limit(90)

            ->all();