MySQL FullText Searching Help

[cx409]

I have a table, with a fulltext index (username) already added...but, when I issue this command with the code, nothing shows up...

Here's the table (or part of it):

User_id > Username
1 > SYSadmin
2 > cx409

And the query...

select username from some_table where match (username) against ('SYS')

I've done this alot of times, but it'll only return rows that's an exact match. Does fulltext searching only work with multiple words or......

PS: It doesn't give me any errors, just Empty set.

 

[legend2]

use the following

select field_name from table_name where field_name like '%string%';


replace table_name, field_name and string by your choice.

 

[cx409]

Ahhh...thanks. Much appreciated.

:P I always knew like was powerful, just didn't know how it worked.

 

[adam_uk]

like is alot slwoer than full text searching

if you want to do part searches you need to use boolean syntax

so if you was searching for "microsoft" you would put this "micro*"

or if you wanted to search for microsoft and office you would use this

"micro* AND office"