How to display records from the database that have a certain value?

Question

Smarty

Hello.
I deduce through foreach an array with the data.

{foreach from=$data item=info}
                    <tr>
                        <td>{$info.A}</td>
                        <td>{$info.B}</td>
                        <td>{$info.C}</td>
                    </tr>
                {/foreach}

How to add a condition so that only those lines are displayed where, for example, the value B = Yes?

Answer 1

And what's the problem either to collect an array in the puff with only the necessary data, or to add if to foreach in the template?
PS what are the reasons for choosing smart? if legacy is ok, if not, not ok.