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 column1 is required, the following 5 results were found.

  1. Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

    print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

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

    Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE 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,...

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

  3. Increment a column in MySQL using the UPDATE queryhttps://joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

    displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined...

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

  4. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

    numeric. SELECT @ParameterToCheck REGEXP '^[A-Za-z0-9]+$' AS AlphaNumeric FROM... Usage -- Using the ORACLE example SELECT Column1, Column2, (LENGTH( TRIM( TRANSLATE( :ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

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

    @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' + (TABLE_SCHEMA + '.' + TABLE_NAME) + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+ @mySearchString +''')' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
Results 1 - 5 of 5

Joes Word Cloud

Please publish modules in offcanvas position.