Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE test (
- `id` INT AUTO_INCREMENT,
- `sentence` VARCHAR(255),
- PRIMARY KEY (`id`)
- );
- INSERT INTO test (sentence) VALUES
- ('This is a web page'),
- ('This is spiderweb'),
- ('Here is a webspider'),
- ('create anyWebPage'),
- ('web in the beginning'),
- ('in the end web'),
- ('werid ,web.');
- SELECT * FROM test WHERE sentence REGEXP '([^[:alnum:]]|^)web([^[:alnum:]]|$)'
Add Comment
Please, Sign In to add comment