Comments - Search is not working

3 years, 8 months ago Leo Schneider

Okay, thank you. Now it works! My code:

SELECT * FROM `suche` WHERE (`titel` LIKE '%dgiu ebugh eruß9g u9ßsh re%' OR `snippet` LIKE '%dgiu ebugh eruß9g u9ßsh re%' OR `text` LIKE '%dgiu ebugh eruß9g u9ßsh re%') AND (`kategorie` LIKE 'Informationen' ) ORDER BY `suche`.`bearbeitungs_datum` ASC, `suche`.`erstellungs_datum` ASC

 
3 years, 8 months ago Daniel Black

For large kategorie lists you can use IN rather than LIKE since there's no pattern match: AND kategorie IN ('Geschichte', 'Informationen', 'Neuigkeiten', 'Fakten rund um den Ort', 'Dir ist langweilig?')

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.