More Fun With Bash Quoting

"...case in point: trying to script the updating of a field in a mysql table when the field to be changed contains quote characters.

"Let's imagine we have a simple table with the following data and we would like to change the name field:

+----+----------------------+---------------------+
| id | name                 | create_date         |
+----+----------------------+---------------------+
|  1 | name 'with' "quotes" | 2009-11-19 08:48:59 |
+----+----------------------+---------------------+

"Your first script might look something like this:"

Complete Story

Related Stories:

• Tech Tip: Find Directories Over a Certain Size(Nov 17, 2009)
• 10 Special Linux Distributions That You Should Know(Nov 17, 2009)
• Command line tricks for smart geeks(Nov 17, 2009)
• Looping the Easy Way(Nov 12, 2009)
• Useless Linux Terminal Commands(Oct 21, 2009)
• Getting comfortable with Linux plumbing(Oct 16, 2009)
• Matching Newlines in Vim(Oct 14, 2009)
• More on Using Bash's Built-in /dev/tcp File (TCP/IP)(Sep 30, 2009)