From a2f3f8a33972bc00521d9656e2086b8e414fd8e2 Mon Sep 17 00:00:00 2001 From: fukachan Date: Wed, 24 Jul 2002 09:28:15 +0000 Subject: tune up sql statements --- fml/etc/src/config.cf.ja/mysql.cf | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/fml/etc/src/config.cf.ja/mysql.cf b/fml/etc/src/config.cf.ja/mysql.cf index 2619f054..a83cda46 100644 --- a/fml/etc/src/config.cf.ja/mysql.cf +++ b/fml/etc/src/config.cf.ja/mysql.cf @@ -24,7 +24,7 @@ sql_get_next_key = select fml_address from $sql_table and fml_domain = '$ml_domain' -sql_getline = select * from $sql_table +sql_getline = select fml_address from $sql_table where fml_ml = '$ml_name' and fml_domain = '$ml_domain' @@ -39,9 +39,9 @@ sql_delete = delete from $sql_table and fml_address = '&address' -sql_find = select * from $sql_table +sql_find = select fml_address from $sql_table where fml_ml = '$ml_name' and fml_domain = '$ml_domain' and - fml_address like '®exp' + fml_address like '%®exp%' -- cgit v1.2.1