Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

SQL

command

-- Generate feed URLs based on subscription type.
IF(ISNUMBER(SEARCH("release", [subscribe])), CONCATENATE([url], "/releases.atom"), IF(ISNUMBER(SEARCH("commit", [subscribe])), CONCATENATE([url], "/commits.atom"), ""))
-- Select all records from table with multi-column sorting.
SELECT *
FROM `table_1`
ORDER BY `column_1` ASC, `column_2` ASC, `column_2` ASC;
-- Search for a string in multiple columns of a table.
SELECT *
FROM `table_1`
WHERE `column_1` LIKE '%string%'
OR `column_2` LIKE '%string%'
OR `column_3` LIKE '%string%';

reference