Comments - Search is not working
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.
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` ASCFor 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?')