diff options
| author | fukachan <fukachan> | 2002-07-24 09:28:15 +0000 |
|---|---|---|
| committer | fukachan <fukachan> | 2002-07-24 09:28:15 +0000 |
| commit | a2f3f8a33972bc00521d9656e2086b8e414fd8e2 (patch) | |
| tree | f2f1118d23610256949fa28d718972d92f08702f /fml | |
| parent | 8e49892e39d6dc1f9b41dd9cddd9a23a628b0e06 (diff) | |
| download | fml8-a2f3f8a33972bc00521d9656e2086b8e414fd8e2.tar.gz fml8-a2f3f8a33972bc00521d9656e2086b8e414fd8e2.tar.bz2 fml8-a2f3f8a33972bc00521d9656e2086b8e414fd8e2.zip | |
tune up sql statements
Diffstat (limited to 'fml')
| -rw-r--r-- | fml/etc/src/config.cf.ja/mysql.cf | 6 |
1 files 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%' |