#!/bin/bash
########################################################################################################
## Author: 	Brian Hunter
## Date:	09/03/2024
## Email:  	brian@sutechy.com
## Script:	mydb.sh
## Description: Script search a MariaDB Database table for a specific string and UPDATE.
########################################################################################################
clear
dbname="mydb_name"
dbuser="mydb_user"
dbpasswd="mydb_passwd"
table="clients"

for line in `mysql -u $dbuser -p$dbpasswd $dbname -e "SELECT * FROM  $table WHERE name_last LIKE '%Georgia%' LIMIT 11" | sed 's/\t/:/g' | grep -v client_id ;`
do printf "LINE=$line\n"
   mysql -u $dbuser -p$dbpasswd $dbname -e "UPDATE $table SET name_first = 'FRANCIS' WHERE client_id = 11"; 
done
exit 0