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..