Skip to content

Instantly share code, notes, and snippets.

@salvadorgascon

salvadorgascon/query.sql

Created April 9, 2023 02:14
Show Gist options
  • Save salvadorgascon/770bfef5e39c935478c38cec7b706d9b to your computer and use it in GitHub Desktop.
Save salvadorgascon/770bfef5e39c935478c38cec7b706d9b to your computer and use it in GitHub Desktop.
Download ZIP
Query ignoring accents and ignore case on PostgreSQL
Raw
query.sql
SELECT Clientes.*
FROM Clientes
WHERE UNACCENT(UPPER(Nombre)) LIKE UPPER('%camion%')
Raw
register_unaccent_function.sql
CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment