MeDoo - Conditional LIKE in the WHERE part

Question

How can I write the follow sql query in MeDoo???

SELECT * FROM lockers WHERE Active = 1 AND GymID = " . $gimid . " AND ForMale = " . $male . 
                    ($filter ? " AND Locker LIKE '%" . $filter . "%'" : "")

The problem for me is the conditional LIKE.

$total = $this->db->count('lockers', 
     ['AND' => [
          'Active' => 1, 
          'GymID' => $gimid, 
          'ForMale' => $male
     ]]
);

Some suggestion???? Thanks a lot!!!

Does this answer your question? [LIKE operator in medoo](https://stackoverflow.com/questions/38461660/like-operator-in-medoo) — gre_gor, Dec 17 '19 at 19:10
Thank you, but are differents statements... in the example below the LIKE always will appear, in my case, if condition FALSE, the LIKE will not included. — Silver Lora, Dec 17 '19 at 20:07

score 1 · Answer 1 · answered Dec 19 '19 at 11:28

Finally, I solved it in the follow way:

// getting locker's total
$total = $this->db->debug()->count('lockers', [
    'AND' => [
        'Active' => 1, 
        'GymID' => $gimid, 
        'ForMale' => $male,
        'Locker[~]' => $filter ? $filter : '' //<- LIKE with empty string shows all
    ]
]);

MeDoo - Conditional LIKE in the WHERE part

1 Answers1