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

  1. Reorder Columns in a Tablehttps://joellipman.com/articles/database/reorder-columns-in-a-table.html

    Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...

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

  2. Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla...

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

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

    without taking security measures. Run the SQL against your new database Open your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old...

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

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

    are you doing 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...

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

  5. K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

    to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the following query: REPAIR TABLE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • 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

    I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...

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

  7. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    using only web-based tools Requires: Web-Based File Manager (eg. cPanel File Manager) Web-Based Database Manager (eg. phpMyAdmin) Recommended if you are working remotely as these tend to let you carry out the actions on the server itself. (ie. Fast &...

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

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

    database. Why? If you're confined to use this product then this is how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you...

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

  9. URL Alias uniqueness with PHP & MySQLhttps://joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

    '_', url_counter); set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
Results 1 - 9 of 9

Joes Word Cloud

Please publish modules in offcanvas position.