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.
making an internal search
Moderator: General Moderators
- xpgeek
- Forum Contributor
- Posts: 146
- Joined: Mon May 22, 2006 1:45 am
- Location: Kyiv, Ukraine
- Contact:
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.
And of course you can use LIKE in you queries.
Also you can use another search engines and libraries.
Re: making an internal search
http://www.sql-tutorial.net/SQL-LIKE.asp?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.
-
thewebdrivers
- Forum Commoner
- Posts: 41
- Joined: Fri Aug 17, 2007 3:32 pm
- Location: india
- Contact:
Code: Select all
select * from table name where columnname like '%abc%'Re: making an internal search
yes nice to have this link..califdon wrote:http://www.sql-tutorial.net/SQL-LIKE.asp?