Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming collate is required, the following 9 results were found.

  1. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + LTRIM(@ColToProcess) + ' COLLATE ' + @p_UseCollation + ', ''' + LTRIM(@ColToProcess) + ''', COUNT(*) AS Count FROM ' + @p_SearchTable + ' GROUP BY ' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  2. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    IF NOT EXISTS `Table1` ( `Column1` int(11) NOT NULL AUTO_INCREMENT, `Column3` int(11) NOT NULL, `Column2` varchar(100) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`Column1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  3. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column_value, ''' + TABLE_SCHEMA + '.' + TABLE_NAME + '.' + COLUMN_NAME + ''' AS column_source...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  4. Search a database for a string (MySQL, T-SQL)https://joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

    out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex": /* USING A CURSOR */ DECLARE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  5. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  6. Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  7. MySQL Updating a database table from another tablehttps://joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

    because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` COLLATE utf8_general_ci LIKE b.`CountryName` COLLATE utf8_general_ci SET a.`ccTLD` = b.`ccTLD`

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  8. Documentation Introductionhttps://joellipman.com/component/content/article/documentation-introduction.html?catid=36

    going to be putting all the articles which document my downloadable products. Please bear with me as I collate all your questions and go into more detail.

    • Type: Article
    • Author: Joel Lipman
    • Category: Documentation
    • Language: *

  9. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    // set the collation of the database and any text fields to 'utf8-general-ci' ALTER DATABASE db_name CHARACTER SET latin1 COLLATE utf8-general-ci; // set text fields to utf8 SET NAMES 'utf8'; This does nothing: // convert the foreign character using PHP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 9 of 9

Joes Word Cloud

Please publish modules in offcanvas position.