Trying to search for a word in a field - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Trying to search for a word in a field

Reply

Search this Thread

#1 (permalink)

Old

01-10-10, 13:48

s0me0ne

s0me0ne is offline

Registered User

Join Date: Jan 2010

Posts: 3

Exclamation

Trying to search for a word in a field

SELECT * FROM posts where match(entry) against('bling');

Gives me the error
#1191 - Can't find FULLTEXT index matching the column list

Is there a way to search without changing the column to "FULLTEXT"? Also what are the cons to changing it to fulltext, will it be slower for regular queries?

Reply With Quote

#2 (permalink)

Old

01-10-10, 15:01

r937

r937 is offline

SQL Consultant

Join Date: Apr 2002

Location: Toronto, Canada

Posts: 19,525

Quote:

Originally Posted by s0me0ne

View Post

Is there a way to search without changing the column to "FULLTEXT"?

yes, all you have to do is specify IN BOOLEAN MODE

Quote:

Also what are the cons to changing it to fulltext, will it be slower for regular queries?

not at all, if your search doesn't use MATCH then the fulltext index is ignored

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Reply With Quote

Reply

Tags

fulltext, match, search

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules