MySQL full text searches

wyrd_fish

Fledgling Freddie
Joined
Dec 27, 2003
Messages
537
does any one here have any experience with full text searches in MySQL???
 

wyrd_fish

Fledgling Freddie
Joined
Dec 27, 2003
Messages
537
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

One of Freddy's beloved
Joined
Jan 9, 2004
Messages
957
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

Resident Freddy
Joined
Dec 22, 2003
Messages
1,007
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
 

Users who are viewing this thread

Top Bottom