| SitePoint Sponsor |
I have a question about fulltext searching. What is it? I have a database of information about games and I'd like it to be searchable by its title (title field) and game description (info field). If I turn those two into fulltext fields, would it speed up searching? Also, what does making a field "primary" do.
SK
Bump!
SK
wow, are you ever patient
almost 90 days from posting the question to bumping it
my advice: use LIKE on your two fields, and forget about fulltext for them
a primary key is unique, not null, and automatically gets an index
Posting Permissions
Bookmarks