I have a table called persons which contains data about, well, people. It also contains foreign keys to another table. I’d like to make a fulltext index that is able to search the related tables for …
Tag: full-text-search
Best approach to index a PostgreSQL database with plain html content?
I have a database with a few million posts, each with a column “content” that contains the post content in plain HTML.
<a href="http://…
Full Text Search on MySQL : Can not search by word after hyphen/dash
I have the following record in DB: ‘Vinyl Exam – CA Only’ So, when I performed the following search: Record is returned, but in this case: Item is not returned. What I should do to return the item in the last case. Answer The reason your search isn’t working is because by default, ther…
Is there an elegant and efficient SQL way of listing all substring positions?
I have a text column in an sql database. My task is to find all occurrences of a given string in the texts, and list the character positions text by text (for backreference later in the application). …
Searching database using `LIKE` and `MATCH AGAINST` in MySQL
I have a table in my database called pro_search where I have translated the meta information for different products in different languages. My table structure is like so:id pro_id en de es fr …
MySQL FullText in Boolean mode: searching keywords that contain ‘+’ as part of the string
I have looked at dozen ‘similar’ questions, without luck. I understand that + attached to a keyword in FULLTEXT in BOOLEAN mode has a special meaning, however, what if our keyword(s) actually contain +…
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
I am getting following error in my SQL server 2008 R2 database: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view ‘tblArmy’ because it is not full-text indexed.
How to search multiple columns in MySQL?
I’m trying to make a search feature that will search multiple columns to find a keyword based match. This query: works only for searching one column, I noticed separating column names with commas results in an error. So is it possible to search multiple columns in mysql? Answer You can use the AND or OR…