[Tom Cappellino]

Heyo,

We have quite a large database here, so when so when someone searches for “Steve Brown” we need only the one Steve Brown to be returned, not 100 Steves and 100 Mr Browns for a page of 200 listings when they just wanted one. (just an example)

It sounds like the solution to this is enabling fulltext for the fields we’re concerned with? Is that accurate? Could you walk me through configuring it with phpMyAdmin?

Thank you

[Steven Zahm]

@ Tom

FULLTEXT search is already supported by Connections, but because there are a large number of hosts that do not allow this do to the increase MySQL load the simple keyword search is enabled by default too. YOu can turn this off and that should help with the search results.

Go to the Connections : Settings admin page, click the Search tab. Here you can disable the keyword search and configure which fields should be queried.

Hope that helps.

[Tom Cappellino]

Thanks Steve. What is required on the MySQL side? I have to create a FULLTEXT index with the appropriate fields?

[Tom Cappellino]

Also, which tables? connections, connections_phone, and connections_term_relationships?

[Steven Zahm]

@ Tom

You don’t need to do anything on the MySQL side. Connections creates the required FULLTEXT indices.

[Tom Cappellino]

Interesting, I did have to create the index myself for it to start finding results. In fact, it still isn’t finding anything if I search by phone number. Id assume because that’s a different table.

[ANA GARZA]

Please help,

I also need the search box to work with AND and not OR (when searching more than one word).

If I search for JUAN GARZA, I don´t want displayed all the JUAN and all the GARZA, just the records that contain Both Words. How can I acomplish that?

Thanks, -Ana Maria

[ANA GARZA]

Now I am using FULLTEXT Search, and it works fine with JUAN MANUEL,
but…

If I search: Notaria 62, it does not work.
If I search: Notaria 129, it does work.

Why don´t it work with 2 letters? If I use “Notaria 62″ Using(” “), then it works. Please help, -Ana Maria

This is where I have the directory:

http://colegiodenotarios.org/organigrama/

Thanks!

[Steven Zahm]

@ ANA GARZA

Sorry, but there is nothing I can do about that, those are limitations to of MySQL and not Connections. The default character is usually 4+ characters so you webhost must have setup MySQL to allow 3+ character searches.

[Ana]

If I use “”, to search a keyword ejm: “notaria 62″, it will work fine. So, can you please let me know in where is the search code and .php file, maybe I can add this ” ” on the code. Thanks, -Ana Maria

[Author]

Posts