searching through a mysql db/tbl

hi... i'm trying to figure out how to approach/solve a few issues. looking through google hasn't made the light shine!! 1) i'm trying to figure out how to allow a user to search through a query/tbl for a given string. ie, if i have the following as the result of a query: name email foo... aa a@b.com dddd b1 aa@f.com 123 bb q@rr.com qwe if i allow a user to search on say 'aa', i'd like the user to be able to get: name email foo... aa a@b.com dddd b1 aa@f.com 123 any ideas as to how i could go about and create the query, or what would i need to do to have this result... 2) if i have a query that produces a number of rows, how/what would i need to do, to limit the number of rows displayed, and to allow the user to select a 'back/next' button that would generate/display the next 'N' items in the list/query results... if anybody could direct me to sample docs/code that kind of describes/solves what i've described, i'd appreciate it!!! thanks -bruce bedouglas@earthlink.net