PostgreSQL: Full Text Search – How to search partial words?

by

Try, 

SELECT title FROM movies WHERE to_tsvector(title) @@ to_tsquery('squire:*')

This works on PostgreSQL 8.4+

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. Using an Alias column in the where clause in Postgresql
  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. Possible to perform cross-database queries with PostgreSQL?
  6. Reset auto increment counter in postgres
  7. GROUP BY and aggregate sequential numeric values
  8. Safely rename tables using serial primary key columns
  9. How to concatenate columns in a Postgres SELECT?
  10. How to use (install) dblink in PostgreSQL?
  11. get JOIN table as array of results with PostgreSQL/NodeJS
  12. updating table rows in postgres using subquery
  13. How can I send email from PostgreSQL trigger?
  14. Find overlapping date ranges in PostgreSQL
  15. PostgreSQL multi INSERT…RETURNING with multiple columns
  16. How do you do date math that ignores the year?
  17. Postgres manually alter sequence
  18. What’s the proper index for querying structures in arrays in Postgres jsonb?
  19. “Operator does not exist: integer =?” when using Postgres
  20. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  21. Oracle equivalent of Postgres’ DISTINCT ON?
  22. Postgres sql insert query syntax error from phpPgAdmin
  23. postgresql generate sequence with no gap
  24. PostgreSQL: Case insensitive string comparison
  25. Combine two columns and add into one new column
  26. Bulk/batch update/upsert in PostgreSQL
  27. Any way to achieve fulltext-like search on InnoDB
  28. Timestamp Difference In Hours for PostgreSQL
  29. SQL INSERT without specifying columns. What happens?
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment