Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

mysql fulltext problem


  • Please log in to reply

#1
mikhael

mikhael

    Member

  • Member
  • PipPip
  • 39 posts
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
  • 0

Advertisements


#2
mikhael

mikhael

    Member

  • Topic Starter
  • Member
  • PipPip
  • 39 posts
Just an update.

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

Solved
  • 0

#3
mikhael

mikhael

    Member

  • Topic Starter
  • Member
  • PipPip
  • 39 posts
Just an update.

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

Solved
  • 0

#4
mikhael

mikhael

    Member

  • Topic Starter
  • Member
  • PipPip
  • 39 posts
Just an update.

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

Solved
  • 0

#5
mikhael

mikhael

    Member

  • Topic Starter
  • Member
  • PipPip
  • 39 posts
Just an update.

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

Solved
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP