Doctrine\Persistence\ManagerRegistry и с помощью него выбираете необходимый EntityManager
SELECT `name` FROM `table` WHERE LOWER(`name`) LIKE '%кедров%'SELECT COUNT(DISTINCT(i.name)) as count
FROM cms_base i
LEFT JOIN cms_join as c ON i.id = c.id_join
LEFT JOIN cms_images as m ON i.id = m.id
WHERE (CONCAT_WS(",", i.test," ", i.test1," ", i.test2," ", i.tes3) LIKE '%test%')
limit 0,20$entity = $builder->getData();'query_builder' => function(EntityRepository $er) use ($entity) {
return $er->createQueryBuilder('c')
->where('c.parent != :category')
->setParameter('category', $entity);После принятия изменений - в таблице user доктрина сама сделала поле roles текстового типа
$search_articles = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_title LIKE ?");
mysqli_stmt_bind_param($search_articles, 's', "%$search%");Возможно ли как-то для поля задать псевдоним через as?
->join('LEFT', '#__categories AS cc ON cc.id = a.catid')SELECT * FROM *your_table_name* WHERE status = 1 LIMIT 3
UNION
SELECT * FROM *your_table_name* WHERE status = 0