Richard Castera - Explorations in Software Development
Richard Castera - Explorations in Software Development
Browsing Tag
sql
Scripts Web Server

MySQL – Using a Column Name Inside the LIKE Keyword

June 14, 2010 7 Comments

When using the LIKE keyword in a MySQL query, I use it the most typical way, LIKE ‘%STRING%’. One day, I was in need to use a column name instead and could not figure out how to do it! At first, I tried to just replace the string value with the column name like this, LIKE (%t.column%). The end-result was not good as the LIKE keyword expects a string.

So, I thought of trying the CONCAT() function since that returns a string. And it worked!

MySQL
1
LIKE CONCAT('%', t.column)

Hope this helps someone!

Continue reading
Reading time: 1 min
Share:
Written by: rcastera
Scripts Web Server

MySQL – How to Export and Import tables with the Command Line

June 13, 2010 2 Comments

2 commands I use often throughout the day is importing and exporting large databases into MySQL VIA the command line. Here is how I do it where “USERNAME” is your username, “PASSWORD” is your password and “DATABASE” is your database name.

To Export:

MySQL
1
mysqldump -uUSERNAME -pPASSWORD DATABASE | gzip -c > ~/dump_2010-06-14.sql.gz

To Import:

MySQL
1
mysql -uUSERNAME -pPASSWORD DATABASE < database.sql

Also, you may have a large database that may give you errors while importing. You can use this command to force the import without warnings or errors:

MySQL
1
mysql -f -uUSERNAME -pPASSWORD DATABASE < database.sql
Continue reading
Reading time: 1 min
Share:
Written by: rcastera

About me

Hello, my name is Richard Castera. I have more than 12 years of experience architecting, implementing, leading and launching large scale, high performance software products in a fast-paced agile environment.

Popular Posts

Magento – Display new products on the home page

May 20, 2009

How to Fix “Internet Explorer Cannot Open the Internet Site- Operation Aborted” Error

May 9, 2009

PHP – Convert Array to Object with stdClass

July 5, 2009

Categories

  • Home Automation
  • Resources
  • Scripts
  • SEO
  • Thoughts
  • Web Server

Tags

Apache Apple Bash CSS Drupal Free home automation htaccess Java Javascript Magento PHP raspberry pi SEO SQL thoughts Wordpress

© 2019 copyright Richard Castera // All rights reserved