Most voted "full-text" questions
7 questions
Sort by count of
-
14
votes3
answers3192
viewsWhat is the difference between Full Text Search and LIKE?
I’ve heard a lot about the term Full Text Search (FTS) lately, and I’ve been told that I should use this instead of drafting the queries with LIKE. But how to use the Full Text Search? What are the…
-
1
votes1
answer1224
viewsInstall Full-text in SQL Server
I plan to use full text index (Full-Text) in my SQL Management Server 2014. I created a catalog with the command: CREATE FULLTEXT CATALOG [noticiasFullText] WITH ACCENT_SENSITIVITY = OFF And when I…
-
1
votes1
answer92
viewsWhat is the best practice for consulting in large tables?
I have a system composed of several tables.One of the tables is called Publications and contains 15 varied fields, 3 of which are the main ones of my doubt: 1. titulo - varchar(100) 2. subtitulo -…
-
1
votes1
answer51
viewsIndex Fulltext is not filtering in select Where
I have a table called boletos, and created a FULLTEXT index for the column categoria, which is the column that will go the most in the search for the Where. I did everything right, only when it’s…
-
1
votes0
answers16
viewsHow to search a sentence literally in postgre
Fellas, I need some help. I’m trying to research a literal phrase in the postgre. I used plainto_tsquery, but he searches the words in the text and not the literal phrase as it was typed. Which…
-
0
votes0
answers28
viewsMysql full text does not find underlined results
I’m using the MATCH/AGAINST of mysql to implement a search system, the problem is that, words with underlining (ex: lista_compras_mercado.txt) are interpreted as one, there is some way to turn…
-
0
votes1
answer114
viewsSort query by Mysqli relevance
how the query below could be ordered by relevance and then by date? $query = $mysqli->prepare( "SELECT `id`, `titulo`, `foto`, `descricao`, `slug`, `data`, '' as `local` FROM `noticias` WHERE…