How do I use SQL LEFT() in Symfony2 query builder?

Question

Here's the line that's making my query fail.

$query = $query->where('a.field LIKE :keyword OR LEFT(a.otherfield, 3) = LEFT(:keyword, 3)');

I get this error:

[Syntax Error] line 0, col 104: Error: Expected known function, got 'LEFT'

This SQL code works:

SELECT * FROM `table`
WHERE field LIKE 'searchterm'
OR LEFT(`otherfield`, 3) = LEFT('searchterm', 3)

Why does LEFT() return an error? Is there a different way to do it with query builder?

You will have to implement your own DQL function, please see this — LMS94
– LMS94, Commented Apr 12, 2016 at 20:05

Community · Accepted Answer · 2017-05-23 10:30:04Z

1

Try to look at this question. Otherwise, try the old school way! native-sql-with-doctrine.

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Apr 13, 2016 at 9:30

Houssem ZITOUN

7321 gold badge9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

chrislebaron · Accepted Answer · 2016-04-15 17:43:22Z

0

@Houssem Zitoun's answer was good, and I'm marking it as the answer because it's relevant to my question. It's not the answer I used however

I already had the query written in sql that I wanted to use, so i decided to use a custom query with doctrine. It explains here how to do it. Symfony2 & Doctrine: Create custom SQL-Query

answered Apr 15, 2016 at 17:43

chrislebaron

3693 silver badges14 bronze badges

Collectives™ on Stack Overflow

How do I use SQL LEFT() in Symfony2 query builder?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related