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

  1. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    `value`) -- SELECT -- 1, 'Joel Lipman', 'Webmaster', @exampleLocalVariable -- FROM -- `my_old_database`.jos_sampletable -- WHERE -- `my_old_database`.jos_sampletable.user_id=1; -- You could copy and paste this whole query and then remove everything --...

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

  2. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    Joomla 3.x -- Banners: UPDATE `v34_db`.`v34_banners` SET `created_by` = @v25_admin_id, `created_by_alias` = @v25_admin_alias WHERE `created_by` = @v34_admin_id; UPDATE `v34_db`.`v34_banners` SET `modified_by` = @v25_admin_id WHERE `modified_by` =...

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

  3. JDatabase: using the Joomla database with exampleshttps://joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    $db->quoteName('#__users', 'u') . ' ON (' . $db->quoteName('u.id') . ' = ' . $db->quoteName('p.user_id') . ')') $query->where($db->quoteName('u.real_name') . ' LIKE '. $db->quote('\'%smith%\'')); $query->order('u.real_name ASC'); // Reset the query...

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

  4. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column...

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

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

    TIME( DATE_ADD( w.date_started , INTERVAL w.actual_duration SECOND ) ) AS TimeOut FROM jdlv2_joestimesheets_works w WHERE DATE(w.date_started)=DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) UNION ALL SELECT DATE( DATE_ADD( NOW( ) ,...

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

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

    search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c) My own...

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

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

    A quick article on how to use the where clause in a joomla database query. 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')...

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

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

    $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY CONCAT(u.FirstName, ' ', u.LastName) "; Activity...

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

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

    Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters...

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

  10. Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    and WeekNumber from the weekstructure table based on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE StartDate BETWEEN DATEADD(day, -6, @specifiedDate) AND DATEADD(day, 6, @specifiedDate)) SET @weekNumber = (SELECT TOP 1...

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

  11. SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

    @StudentReference [int] respectively). Most of the remaining datasets use the resulting @StudentReference number in their "where" clause. A student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So...

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

  12. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

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

    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 converted to a number only retrieves the first value before...

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

  14. MySQL: Find records in one table that are not in another.https://joellipman.com/articles/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

  15. Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    this operator to search for an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs exactly 5 times, you specify the regular expression: a{5} This expression matches: aaaaa The expression does...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  16. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    FROM "Purchase Order Items" poi2 LEFT JOIN "Purchase Orders" po2 ON po2."Purchase Order ID" = poi2."Purchase Order ID" WHERE poi2."Item Name" IN ( 'delivery' , 'Delivery' ) GROUP BY po2."Purchase Order ID" ) pshipping ON pshipping."PO ID" = po."Purchase...

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

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

    value (Maximum) ** ** ** ** Additional: ** ** - For performance, restrict this by schema otherwise occurrences in tables where the column is ** ** the referred to in a view, will appear twice: ** ** Change: ** ** WHERE DATA_TYPE IN ('char', 'nchar',...

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

  18. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

    DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS...

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

  19. SQL Queries for Statisticshttps://joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    t1.Date Date FROM ( SELECT MAX(a.VisitorID) ID, a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON...

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

  20. List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID,...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
Results 1 - 20 of 218

Joes Word Cloud

Please publish modules in offcanvas position.