Difference between LIKE and ~ in Postgres

by

~ is the regular expression operator, and has the capabilities implied by that. You can specify a full range of regular expression wildcards and quantifiers; see the documentation for details. It is certainly more powerful than LIKE, and should be used when that power is needed, but they serve different purposes.

More Related Contents:

  1. Is there a shortcut for SELECT * FROM?
  2. Regular expression in PostgreSQL LIKE clause
  3. How to return result of a SELECT inside a function in PostgreSQL?
  4. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  5. Pivot on Multiple Columns using Tablefunc
  6. What is the maximum number of columns in a PostgreSQL select query
  7. Humanized or natural number sorting of mixed word-and-number strings
  8. Pass multiple values in single parameter
  9. Custom SERIAL / autoincrement per group of values
  10. How do I determine the last day of the previous month using PostgreSQL?
  11. postgres column “X” does not exist
  12. Multiple CTE in single query
  13. Return pre-UPDATE column values using SQL only
  14. Selecting data into a Postgres array
  15. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  16. PostgreSQL: encoding problems on Windows when using psql command line utility
  17. Aggregate a single column in query with many columns
  18. Aggregating (x,y) coordinate point clouds in PostgreSQL
  19. Does Postgres support nested or autonomous transactions?
  20. PostgreSQL delete with inner join
  21. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  22. Update a column of a table with a column of another table in PostgreSQL
  23. Check if NULL exists in Postgres array
  24. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  25. How to compare dates in datetime fields in Postgresql?
  26. How to perform a select query in a DO block?
  27. Cannot SELECT from UPDATE RETURNING clause in postgres
  28. Subtract hours from the now() function
  29. Query for count of distinct values in a rolling date range
  30. SQL Populate table with random data

Leave a Comment