Using a subquery in a LIKE statement
Something like this should work :

select nm_linha from linhas where cidades_origem like CONCAT('%', (subquery_goes_here) ,'%')


For example :

SELECT * 
FROM films
WHERE titre LIKE CONCAT('%', (SELECT  'fella'),  '%')

+---------+------------+
| id      | titre      |
+---------+------------+
|       1 | Goodfellas |
+---------+------------+
1 row in set (0.01 sec)