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

  1. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    MySQL is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an...

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

  2. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly......

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

  3. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the...

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

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

    replace(@sql,'INTO SearchTMP','') END UPDATE @SQLTbl SET Execstatus = 1 WHERE Tablename = @tmpTblname END SET NOCOUNT OFF GO MySQL Source: http://kedar.nitty-witty.com/blog/search-through-all-databases-tables-columns-in-mysql - Kedar at Nitty-Witty.com...

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

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

    used to use a lot more PHP but since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM Table1 WHERE...

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

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

    have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want:...

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

  7. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    screenshot when adding a user to a database: Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external file:...

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

  8. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The...

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

  9. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query ("UPDATE 'accounts' SET 'balance' = 'balance'-1000000 WHERE 'user' = 'Bob'"); $mysqli->query ("UPDATE 'accounts' SET...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB

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

    echo $my_count; -- If you try to retrieve the data before doing the count, you should get the following error: Warning: mysql_num_rows(): 80 is not a valid MySQL result resource in libraries\joomla\database\database\mysql.php on line 344 INSERT using...

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

  11. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

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

  12. MySQLhttps://www.joellipman.com/articles/else/database/mysql.html

    • Type: Category
    • Language: en-GB

  13. MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-data-type-reference-table.html

    A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...

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

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

  15. Inserting incremental weeks in MySQLhttps://www.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

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

    Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

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

    What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric...

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

  18. MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-updating-a-database-table-from-another-table.html

    What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was...

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

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

    migration script. Why use a script? Well apps like jUpgrade didn't work for me. This is how to manually migrate using a MySQL database management tool like PhpMyAdmin. I'm not too bothered about upgrading my own personal site (Joomla 1.5), it's just the...

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

  20. Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME',...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
Results 21 - 40 of 75