H2U4Ksqs

1SELECT * FROM tbl WHERE name LIKE '%a%';
2	
3SELECT * FROM tbl WHERE name LIKE 'a%';
4	
5DROP TABLE IF EXISTS tbl;
6CREATE TABLE IF NOT EXISTS tbl (name TEXT, family TEXT);
7INSERT INTO tbl VALUES
8    ('ali','rezaei'),
9    ('amir','hoseini'),
10    ('milad','karimi'),
11    ('alireza','amiri'),
12    ('hossein','mahmoodi'),
13    (' ali','rezaei'),
14    (' amir','hoseini'),
15    (' milad','karimi'),
16    (' alireza','amiri'),
17    (' hossein','mahmoodi')
18;
19	
20SELECT * FROM tbl WHERE name LIKE '%a%';
21SELECT * FROM tbl WHERE name LIKE 'a%';
22SELECT * FROM tbl WHERE LTRIM(name) LIKE 'a%';