Display the ‘url_addr’, which start with g, c or m



CREATE TABLE mytb (url_id int, url_addr varchar(100));

INSERT INTO mytb VALUES (1, 'google.com');
INSERT INTO mytb VALUES (2, 'microsoft.com');
INSERT INTO mytb VALUES (3, 'apple.com');
INSERT INTO mytb VALUES (4, 'google.com');
INSERT INTO mytb VALUES (5, 'cnn.com');
INSERT INTO mytb VALUES (6, 'apple.com');



            SELECT * FROM mytb 
                        WHERE url_addr IS LIKE 
                        g% OR c% OR m%


Post a Comment