search MySQL Database

Anyone know how to do a search of a MySQL database using SELECT * FROM table_name WHERE MATCH(field_name) AGAINST(search_querry)?

Some sample code would be appriciated.

Thanks

Artoo Smith
artoo_s@hotmail.com

is it single search criteria or multiple?

trying to set up for both.

Artoo Smith
artoo_s@hotmail.com

well the basic single search query would be as follows

select * from my_table where my_field like '%my_search_term%'

that would select any records in my_field that either matched or contained my_search_term.

As for as multiple keyword searches, just use the OR operator like so

select * from my_table where my_field like '%my_search_term%' or my_field like '%my_search_term2%'

this will find any records that contain either my_search_term or my_search_term2

Of course this is a basic explaination, so for a more indepth look at searching, check out Matts tutorial at:

http://codewalkers.com/tutorials/46/1.html

Thanks for the info!! Will take a look at that tutorial as well. Is it possible to search two fields of a database using this method?

Thanks again

Artoo Smith
artoo_s@hotmail.com

yes it is, use the AND operator like so...

select * from my_table where my_field like '%my_search_term%' AND my_field2 like '%my_search_term2%'

or for multiple searches

select * from my_table where (my_field like '%my_search_term%' or my_field like '%my_search_term2%') and (my_field2 like '%my_search_term3%')