How to use SQL LIKE condition with multiple values in PostgreSQL?

by

Perhaps using SIMILAR TO would work ?

SELECT * from table WHERE column SIMILAR TO '(AAA|BBB|CCC)%';

More Related Contents:

  1. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  2. PL/pgSQL checking if a row exists
  3. Compute percents from SUM() in the same SELECT sql query
  4. Postgres analogue to CROSS APPLY in SQL Server
  5. How to find a table having a specific column in postgresql
  6. Postgres function returning table not returning data in columns
  7. Check if NULL exists in Postgres array
  8. How to create a new database with the hstore extension already installed?
  9. How to perform a select query in a DO block?
  10. Join a count query on generate_series() and retrieve Null values as ‘0’
  11. PostgreSQL – dynamic value as table name [duplicate]
  12. Select rows which are not present in other table
  13. Optimize GROUP BY query to retrieve latest row per user
  14. How to implement a many-to-many relationship in PostgreSQL?
  15. Check if value exists in Postgres array
  16. Is there a shortcut for SELECT * FROM?
  17. sql statement error: “column .. does not exist”
  18. What is the difference between single quotes and double quotes in PostgreSQL?
  19. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  20. Best way to count rows by arbitrary time intervals
  21. Sorting null values after all others, except special
  22. Reference alias in WHERE clause
  23. How to compare the current row with next and previous row in PostgreSQL?
  24. ERROR: functions in index expression must be marked IMMUTABLE in Postgres
  25. Why postgres returns unordered data in select query, after updation of row?
  26. Continuing a transaction after primary key violation error
  27. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  28. PostgreSQL – fetch the rows which have the Max value for a column in each GROUP BY group
  29. Parallel unnest() and sort order in PostgreSQL
  30. Is there a postgres CLOSEST operator?

Leave a Comment