How to write replace string function inside Yii2 query

Question

I have a MySQL query which selects column based on the replace string values passed to a column

SELECT * FROM Table WHERE REPLACE(column_name, '.', '') = 'value';

In the above query i remove dot values from the column_name of the table and I pass values with out dots and it works fine.

Now i need to make this query to work in Yii2 query

I have a query in Yii2 like below,

$Table= Table::findOne([ column_name => \Yii::$app->request->post('value')]);

How can i make the first query condition work in Yii2 query?

vishuB · Accepted Answer · 2019-01-21 09:57:23Z

2

Use Like

$Table= Table::find()
      ->where(["REPLACE(column_name, '.', '')" => \Yii::$app->request->post('value')])
      ->one();

answered Jan 21, 2019 at 9:39

vishuB

4,2555 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2019-01-21 09:48:08Z

1

a simple way is the use of string format in where condition

  $Table= Table::find()->where("REPLACE(column_name, '.', '') = 'value'")->one();

you can find useful sample in this guide

answered Jan 21, 2019 at 9:48

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges