Advanced Search

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

  1. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    contains non-alphanumeric characters and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  2. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work errored persistently...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

    be the problem? Able to run the SQL queries directly against the database? Matched the datatypes received/returned by functions, classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 61 - 63 of 63