How to make SQL query with LIKE in YII2?

Question

Yii

Doing a site search with LIKE? it turns out this line:

$query = Course::find()->where(['like', 'name', $q]);

This is a search only on the name field , but how can I make the search be on several fields. For example name, content, keywords, description?

Answer 1

Course::find()->where(['like', 'name', $q])
    ->orWhere(['like', 'content', $q])
    ->orWhere(['like', 'keywords', $q])
    ->orWhere(['like', 'description', $q])

In general, if you are doing a search on the site (and judging by the text of the question, you are doing it), for example, use full-text search , and even better - search engines like sphinx

Answer 2

andWhere
$query = Course::find()->where(['like', 'name', $q])
$query = Course::find()->andWhere(['like', 'content', $ cont])