× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Select row where field contains certain values

Jan van de Laar

New Member

Posts: 5

10 år 4 dagar sedan #460 av Jan van de Laar

Select row where field contains certain values skapades av Jan van de Laar

Hi All

I've built a component with two tables, one of them is named 'categorie'. I can select more than one. In the database there is a field "categorie" and it contains " 1, 3 ". So this row matches with categories 1 and 3.
Now I want to select the proper rows in my frontend view and I want to use this where clause:

$query->where($db->quoteName('categorie') . ' = 1 ');

But this only works with value 1, when I try value 3 there are no database results. I tried using LIKE but that doen't work either. Can someone please help me with this?

Be Logga in eller Skapa ett konto ansluta till konversationen.

Jan van de Laar

New Member

Posts: 5

10 år 3 dagar sedan #461 av Jan van de Laar

Svar från Jan van de Laar i ämnet Select row where field contains certain values

Just found the solution:

// Construct the search term by escaping the user-supplied string and, if required, adding the % wildcard characters manually.

$cat = '%' . $db->escape( $cat, true ) . '%' ;

// Construct the SQL query

$query = 'SELECT * FROM #__table WHERE `categorie` LIKE ' . $db->quote( $db->escape( $cat ), false );

Be Logga in eller Skapa ett konto ansluta till konversationen.

Sidan laddades på: 0.046 sekunder