search whole database
Posted: Wed Nov 26, 2003 5:58 pm
hey,
just wondering....i have a databse of my record collection. its a simple one designed only so i can learn to use mysql with php. my question here regards sql. is there are way to search the whole table or several tables (the whole database) for a search phrase entered by the user? the way i understand it now, i will have to provide a drop down menu or similar to allow the user to decide what to search for, a album name, band name or year (take a look at http://www.ultimate-guitar.com tab search) and then use a sql query based on that.
any help would be appreciated.
tnx
kumar
just wondering....i have a databse of my record collection. its a simple one designed only so i can learn to use mysql with php. my question here regards sql. is there are way to search the whole table or several tables (the whole database) for a search phrase entered by the user? the way i understand it now, i will have to provide a drop down menu or similar to allow the user to decide what to search for, a album name, band name or year (take a look at http://www.ultimate-guitar.com tab search) and then use a sql query based on that.
any help would be appreciated.
tnx
kumar