Shell Programming and Scripting

i want to do something like this from shell, for any user without having to enter any passwords

i want to store the value in the option_value column into a variable

Code:

select option_value from `$databasename`.`wp_options` where option_name="template";

what is the command i should use?

Code:

$var=mysql select option_value from `$databasename`.`wp_options` where option_name="template"
doesnt work

the $database name is stored in a variable

how can i use a mysql statement like this from shell?

thank you!

---------- Post updated at 03:43 AM ---------- Previous update was at 02:59 AM ----------

i think i got something that works

Code:

result=$(mysql -sN -e "select option_value from $dbname.wp_options where option_name='template'")
echo $result