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