> When if have the keyword 'msq' i can match the field 'mysqldata' > SELECT * FROM table WHERE field LIKE "$keyword%" > But how do i get a match when the keyword is 'mysqldatabase' and the field > 'mysql'? (TRUE cause keyword contains 'mysql'). > That'll never work unless you know where to divide up the "keyword" into separate words. The way you want it, why not return everything with an "a" in it, since the keyword contains 'a'?? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php