Например, удобно сделать для поиска по нескольким таблицам.
[sql]
CREATE OR REPLACE VIEW tbl_view_search AS
SELECT CONCAT(‘post_’, id) AS id, id AS source_id, text, CONCAT(‘/’, url) AS url, title, logo AS img, NULL AS price FROM posts UNION
SELECT CONCAT(‘product_’, id) AS id, id AS source_id, text, CONCAT(‘/path/to/’, url) AS url, title, img, price FROM products;
[/sql]

Поиск и замена подстроки в таблице table поля field:
[code]UPDATE table SET field = REPLACE(field, ‘старая строка’, ‘новая строка’);[/code]

Экспорт:

[php]$ mysqldump -u db_username -p db_name > db.sql[/php]

Импорт:

[php]$ mysql -u db_username -p db_name < db.sql[/php]