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

  1. Convert foreign characters to English alphabethttps://joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

    return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A'); UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'Á', 'A');...

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

  2. Modifying columns in a tablehttps://joellipman.com/articles/database/modifying-columns-in-a-table.html

    better DBMS tools). All SQL -- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE...

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

  3. Quickly update all content in mySQL database replacing a stringhttps://joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

    Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' ';...

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

  4. Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

    Values : Table of three columns: ** ** - myValue: value specified in parameter 1 (matched in database to search) ** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records...

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

  5. Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

    character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES ('1', 'It''s amazing!'); Bear this in mind...

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

  6. MySQL: Find all non-alphanumeric rowshttps://joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

    symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT *...

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

  7. Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

    the related tables as well? How? You need to refer to the tables just after the DELETE clause (so instead of DELETE FROM myTable WHERE myValue=givenValue): DELETE s, ssf, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON...

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

  8. Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

    = "my_database_password"; // Password for database authentication $db_name = "my_database"; // Database name $db_table = "mytable_countryipranges";// Database table Upload the PHP file to your website Test by using a web browser to visit:...

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

  9. SQL: Use CASE for Relevance columnhttps://joellipman.com/articles/database/mysql/sql-use-case-for-relevance-column.html

    THEN 10 WHEN columnLastName LIKE @ThisSearch THEN 10 WHEN columnFullName LIKE @ThisSearch THEN 1 END as relevance FROM myTable WHERE s.columnPublished

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

  10. Joomla WHERE clause with ORhttps://joellipman.com/articles/cms/joomla/joomla-where-clause-with-or.html

    Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') Method #1 - chain: $query ->where($db->quoteName('condition1') . ' = '....

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

  11. Trim values along with the tabhttps://joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

    to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`)); Source: Stack Overflow - How to Remove Tabs

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 1 - 11 of 11

Joes Word Cloud

Please publish modules in offcanvas position.