MySQL full text searches

[wyrd_fish]

does any one here have any experience with full text searches in MySQL???

 

[Jonty]

Hi wyrd_fish

I've never really needed to use it myself, but I've heard many good things about it. Having just done a quick Google search these links may, or may not, be of some use:

• Dev Article's 'Getting Started with MySQL's Full Text Capabilities'
• Zend's 'Using MySQL Full Text Searching'
• MySQL Manual's Full Text Page

Kind Regards

 

[wyrd_fish]

yeah, i used the zend one to make my script, before realising it was not the right tool for teh job


say, that want to search a list of user names using MySQL & PHP, but only have part of the UN...

eg. i only have "wyrd" out of "wyrd_fish"

how would i go about implimenting it???

 

[`mongoose]

I am just trying to think what the wildcard character is for MySQL or SQL I think it's %

So for a like query it would be
"select * from User_table where Username LIKE string & %

or something like that

Been a while since I did any sql stuff

M

 

[Doh_boy]

Same here as regards to using my_sql BUT I'm sure it was the above BUT "wryd%" which will look for things wyrdXXX

Obviously if you want XXwyrdXXX you'd do "%wyrd%"

Not sure though, I get mixed up between oracle and my_sql a lot. (even though it's "_wyrd_" in oracle I'm sure). :s