Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Free text search
- Thread starter ashz
- Start date
in the entire field and in all the records?Im not sure I understood you correctly, but this will work for a search in a one column in one table.
SELECT * FROM table_name WHERE column_name like '%omni%'
If your using a string from a html form text field the $_GET variabel you have for that value can just be inserted into the search string, ie:
...like '%$variable%'
SELECT * FROM table_name WHERE column_name like '%omni%'
If your using a string from a html form text field the $_GET variabel you have for that value can just be inserted into the search string, ie:
...like '%$variable%'
- Thread starter
- #3
danielhozac
Programmer
Code:
SELECT * FROM <table> WHERE <column_1> LIKE '%<string>%' OR <column_2> LIKE '%<string>%'- Thread starter
- #5
- Status
Similar threads
- Locked
- Question