Augusta Engineering & Adventures: PostgreSQL Cari text tanpa peduli besar kecil dan posisi

Select the title and description columns from the film table.
Perform a full-text search on the title column for the word elf.

-- Select the title and description
SELECT title, description
FROM film
-- Convert the title to a tsvector and match it against the tsquery 
WHERE to_tsvector(title) @@ to_tsquery('elf');

titledescription
GHOSTBUSTERS ELFA Thoughtful Epistle of a Dog And a Feminist who must Chase a Composer in Berlin
ELF MURDERA Action-Packed Story of a Frisbee And a Woman who must Reach a Girl in An Abandoned Mine Shaft
ENCINO ELFA Astounding Drama of a Feminist And a Teacher who must Confront a Husband in A Baloon

Augusta Engineering & Adventures

Label

PostgreSQL Cari text tanpa peduli besar kecil dan posisi

Tidak ada komentar:

Posting Komentar

title	description
GHOSTBUSTERS ELF	A Thoughtful Epistle of a Dog And a Feminist who must Chase a Composer in Berlin
ELF MURDER	A Action-Packed Story of a Frisbee And a Woman who must Reach a Girl in An Abandoned Mine Shaft
ENCINO ELF	A Astounding Drama of a Feminist And a Teacher who must Confront a Husband in A Baloon