How to use LIKE option in query in datagrid file?

How use LIKE in datagrid.yml with %, eg link like “%word%”.

Native SQL looks

MySQL

select * from table where link like '%word%';

1	select * from table where link like '%word%';

Topic

[RodolfoParticipant]

Hi @vitaliybelous

When I had to use this format of query, I was passing the value (word in your example) as a parameter from the template. So the query on the datagrid was something like this:

YAML

where: and: - tableAlias.fieldName LIKE :parameterName bind_parameters: - parameterName

1 2 3 4 5

where:             and:                 - tableAlias.fieldName LIKE :parameterName     bind_parameters:         - parameterName

Keep in mind that depending of the amount of data you’re trying to search it can get very slow.

[Author]

Replies