From 8987ff78182d4583f38138fb365c1a8993369705 Mon Sep 17 00:00:00 2001 From: Norbert Moutarde Date: Sat, 29 Jun 2013 15:51:18 +0200 Subject: [PATCH] search wasn't noted correctly ... --- alias.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/alias.sql b/alias.sql index c21fff9..209b9c5 100644 --- a/alias.sql +++ b/alias.sql @@ -1,4 +1,4 @@ INSERT INTO alias (nom, command, argc) VALUES ('ls', 'select id,texte from raw order by date asc;', 0); -INSERT INTO alias (nom, command, argc) VALUES ('search', 'select id, texte from raw where texte like ''%1'' order by date asc', 1); +INSERT INTO alias (nom, command, argc) VALUES ('search', 'select id,texte from raw where texte ~ $1 order by date asc;', 1); INSERT INTO alias (nom, command, argc) VALUES ('rm', 'DELETE FROM raw WHERE id =''%1'';', 1); INSERT INTO alias (nom, command, argc) VALUES ('alias', 'select nom from alias;', 0); -- 2.45.1