PHP search function to look in pgsql table

Question

I want to make a search function in my website. I want to search for a string in all fields of my table (about 13 columns). If one row contains a field that matches the string (like operator) I want it to be added to result.

Example

|field 1 | field 2 | field 3|
 some      string     test    
 test      some      string
 one       simple    string

Now basically if I search for the string "test" I want to have the first two rows.

Is there a wildcard option for WHERE that I could do something :

SELECT * from my.table WHERE * like '%string%';

No, you need to write the WHERE clause. It's much less typing than you did to write this question. Just throw the column names into an array and loop over it to produce the list of ORed comparisons. — Dan Grossman
– Dan Grossman, Commented Jul 21, 2011 at 9:29
Whatever technique you use, it's going to produce a dead slow query. — Spudley
– Spudley, Commented Jul 21, 2011 at 9:54

user330315 · Accepted Answer · 2011-07-21 10:02:38Z

2

There is no such syntax in PostgreSQL (or any other DBMS).

As Spudley pointed out using a query like like '%string%' will be quite slow.

If this is something that is needed very often you should definitely look into PostgreSQL's full text search capabilities.

answered Jul 21, 2011 at 10:02

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP search function to look in pgsql table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related