|
Web design and Programming Discuss website creation and other programming topics. |
|
Thread Tools | Search this Thread | Display Modes |
#1
|
||
|
Search in MySQL
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.
__________________
- My: Drawings, rants, raves, my cat, designs, and everything else i want to put on the net. Free Teamspeak servers: http://gamersnetwork.us/ |
#2
|
||
|
$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!
__________________
04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq |
#3
|
||
|
Awesome, i will have to use that to for my resource site map db, and file db!
|
#4
|
||
|
Thanks P, also do you know of a site that has all the mysql queries that you can use, such as DISTINCT etc...?
__________________
- My: Drawings, rants, raves, my cat, designs, and everything else i want to put on the net. Free Teamspeak servers: http://gamersnetwork.us/ |
#5
|
||
|
__________________
http://addf.net http://som.addf.net http://snmservers.com http://snmfuturedomination.com ------------------------------------- but there it's a different movie she stares into the screen and fantasies enter her harder than all those who will get to know her |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Movie search | IcIshoot | General Chat | 3 | 07-19-2008 03:05 PM |
Search! | atholon | Web design and Programming | 7 | 05-09-2005 05:54 PM |
Search Problems | GeeFuss | Feedback / Novahq.net Support | 2 | 02-06-2005 11:30 PM |
The search is on... | NaughtyPerry | Sigs and Graphics | 10 | 10-23-2004 07:56 PM |