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

  1. Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business...

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

  2. Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    1 Welcome This is Joomla 2 Copyright This site and its design is property of JoelLipman.com HP Articles (table name: jos_hp_items): id name description -------------------------------------------------------------------------- 1 Welcome This is HP 2...

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

  3. MySQL: Find records in one table that are not in another.https://joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...

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

  4. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

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

  5. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Hopefully the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open......

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

  6. MySQL last year week month day trend periodshttps://joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or...

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

  7. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when...

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

  8. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    Given Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00...

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

  9. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year...

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

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

    What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

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

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

    What? So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational...

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

  12. Access MySQL databases using Oracle SQL Developerhttps://joellipman.com/articles/else/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    What? So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using...

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

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

    What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to...

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

  14. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is...

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

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

    What? So this is an article to serve as documentation for one of the data sources available to download for FREE from this site. Why? It's useful to have a CSV list of all the IP ranges and their allocated country. Our use here was to create a...

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

  16. Generate a Timesheet in MySQL https://joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and...

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

  17. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    Applies to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...

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

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

    What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started...

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

  19. MySQL: Count occurrences of words in a columnhttps://joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    What? This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used...

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

  20. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    Aims / Objectives Deadlines / Milestones Target Audience (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for Joellipman.com below) Similar...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 421 - 440 of 656