How to make a query with a text string (literal string) in yii2 query builder?

Question

MySQL

Need a query like this

SELECT CategoryID, CategoryName, 'Northwind Category' AS Note
FROM categories;

Here it works:

$query = (new \yii\db\Query())
    ->select("CategoryID, CategoryName, CONCAT('Northwind Category', '' ) AS Note")
    ->from('categories');

What other options are there?

Answer 1

1) Use the string concatenation function of your DBMS

$query = (new \yii\db\Query())
    ->select("CategoryID, CategoryName, CONCAT('Northwind Category', '' ) AS Note")
    ->from('categories');

2) Use Expression

$query = (new \yii\db\Query())
    ->select([
         'CategoryID', 
         'CategoryName', 
         'Note' => new  \yii\db\Expression("'Northwind Category'")])
    ->from('categories');

Answer 2

$query= (new \yii\db\Query())
    ->from('categories')
    ->where(['Note' => 'Northwind Category'])
    ->all();