Page 1 of 1

making an internal search

Posted: Tue Aug 28, 2007 12:52 am
by montyauto
i need to make an internal search for my website.

I need to be able to search through maybe 5-10 Mysql tables. the thing i was looking into was the LIKE function in mysql...

but, i dont really know how to use that...

any help would be appreciated, or a good script others use.

Posted: Tue Aug 28, 2007 4:37 am
by xpgeek
For Mysql search you can use MySQL FULLTEXT index.
And of course you can use LIKE in you queries.
Also you can use another search engines and libraries.

Re: making an internal search

Posted: Tue Aug 28, 2007 12:44 pm
by califdon
montyauto wrote:i need to make an internal search for my website.

I need to be able to search through maybe 5-10 Mysql tables. the thing i was looking into was the LIKE function in mysql...

but, i dont really know how to use that...

any help would be appreciated, or a good script others use.
http://www.sql-tutorial.net/SQL-LIKE.asp?

Posted: Tue Aug 28, 2007 1:03 pm
by thewebdrivers

Code: Select all

select * from table name where columnname like '%abc%'
you can use the percent sign as you like. % is a wildcard character and equivalent to "any set of characters"

Re: making an internal search

Posted: Tue Aug 28, 2007 9:31 pm
by montyauto
yes nice to have this link..