Search in MySQL

[BeBop]

How do you search for a something in a MySQL db with some user input... i remember something vaguely along using the percent signs in it soemwhere % % but i dont know where.

Thanks in Advance.

[Scott]

$query=mysql_query("SELECT * FROM table_name WHERE coloum_name LIKE '%search_term%'");

%search_term% will display anything with the word search_term in it. Exapmle: This_is_a_search_term_Cool!

%search_term will display anything with the word search_term in it. Exapmle: This_is_a_search_term

search_term% will display anything with the word search_term in it. Exapmle: search_term_Cool!

[JonM]

Awesome, i will have to use that to for my resource site map db, and file db!

[BeBop]

Thanks P, also do you know of a site that has all the mysql queries that you can use, such as DISTINCT etc...?

[prey]

http://mysql.com
http://www.w3schools.com/sql/default.asp