Databases: searching for a word in entries containing multiple words using 'like'

If you were using CI 4 the query would be very simple, as below:

PHP Code:

public function getXpt()
    {
        $db = $this->db;
        $search = 'Taylor';        
        $query = $db->table('names')
        ->where('name', $search)
        ->orLike('name', $search.'%')
        // here the 'join' would enter
        ->orderBy('name', 'ASC')        
        ->get();

        return $query->getResult(); 


Table is about music and film artists.

Attached Files

Thumbnail(s)