[mikhael]

I have a small table with a few columns one is named "name" and I want to search through the entire table and grab all the columns that share a name and return all of the subsequent columns in that row.

here is my working sql string:

select * from clients where match (name) against ('$sentname');
where $sentname is the name to be searched for.

This is working at 99% I am only running into a problem when attempting to find "Jimmy Johns"

(the table has business names in it)

ANY other business name (or a portion of said business name) returns the results flawlessly, however searching Jimmy Johns, Jimmy, John, Johns or any other variation gives me NO results.
This is so weird

[Advertisements]

Just an update.

I discovered that fulltext will not return a result if more than 50% of the rows would be returned.

Solved

[mikhael]

Just an update.

I discovered that fulltext will not return a result if more than 50% of the rows would be returned.

Solved

[mikhael]

Just an update.

I discovered that fulltext will not return a result if more than 50% of the rows would be returned.

Solved

[mikhael]

Just an update.

I discovered that fulltext will not return a result if more than 50% of the rows would be returned.

Solved

[mikhael]

Just an update.

I discovered that fulltext will not return a result if more than 50% of the rows would be returned.

Solved