minte9
LearnRemember MYSQL

Login

SELECT
Order By Rand
Concat Fields
Between
Regexp
If Null
Union
Replace
Using Syntax
Substring
DATE
Get Date
Date Format
Today
Month Day
Date Parts
ADMINISTRATION
Foreign Key
Foreign Key Disable
Innodb
Create Database
Create Table
Add Column
Add Index
Data Type
Primary Key
Errors
Indexes
Mysqldump
Table Definition

MYSQL PAGES - LEVEL 3

Select

 
SELECT REPLACE(catg, "-", "_") FROM catgs;

Update

 
UPDATE page SET title = REPLACE(title, CONCAT(catg, " ",subcatg, " "), "");

References:

High Performance MySQL, Baron Schwartz / amazon.com

2010 - 2026