Filtering MySQL Table

SELECT * FROM my_table WHERE my_field LIKE '%query%' LIMIT 10;

Backup MySQL

mysqldump -u root -p database > database.sql
mysqldump -u root -p database table > table.sql