SQL LIKE condition to check for integer?

by

That will select (by a regex) every book which has a title starting with a number, is that what you want?

SELECT * FROM books WHERE title ~ '^[0-9]'

if you want integers which start with specific digits, you could use:

SELECT * FROM books WHERE CAST(price AS TEXT) LIKE '123%'

or use (if all your numbers have the same number of digits (a constraint would be useful then))

SELECT * FROM books WHERE price BETWEEN 123000 AND 123999;

More Related Contents:

  1. Refactor a PL/pgSQL function to return the output of various SELECT queries
  2. Is SELECT or INSERT in a function prone to race conditions?
  3. Any downsides of using data type “text” for storing strings?
  4. Index for finding an element in a JSON array
  5. Query for array elements inside JSON type
  6. Calculating Cumulative Sum in PostgreSQL
  7. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  8. Is it possible to make a recursive SQL query?
  9. Way to try multiple SELECTs till a result is available?
  10. Split given string and prepare case statement
  11. Column ‘mary’ does not exist
  12. Get top row(s) with highest value, with ties
  13. Double colon `::` notation in SQL
  14. Delete parent if it’s not referenced by any other child
  15. PostgreSQL wildcard LIKE for any of a list of words
  16. Query that ignore the spaces
  17. Export specific rows from a PostgreSQL table as INSERT SQL script
  18. SQL query to get most recent row for each instance of a given key
  19. Postgres constraint for unique datetime range
  20. Postgres function returning table not returning data in columns
  21. PostgreSQL create table if not exists
  22. Get values from first and last row per group
  23. How can I add a column that doesn’t allow nulls in a Postgresql database?
  24. Create PostgreSQL ROLE (user) if it doesn’t exist
  25. Count cumulative total in Postgresql
  26. PostgreSQL column ‘foo’ does not exist
  27. Prepared Statement on Postgresql in Rails
  28. Postgresql query between date ranges
  29. How to use SQL LIKE condition with multiple values in PostgreSQL?
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment