Guest User

http://stackoverflow.com/questions/16001848/sql-command-can-

a guest
Apr 14th, 2013
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.39 KB | None | 0 0
  1. CREATE TABLE test (
  2.   `id` INT AUTO_INCREMENT,
  3.   `sentence` VARCHAR(255),
  4.   PRIMARY KEY (`id`)
  5. );
  6.  
  7.  
  8. INSERT INTO test (sentence) VALUES
  9. ('This is a web page'),
  10. ('This is spiderweb'),  
  11. ('Here is a webspider'),    
  12. ('create anyWebPage'),
  13. ('web in the beginning'),
  14. ('in the end web'),
  15. ('werid ,web.');
  16.  
  17. SELECT * FROM test WHERE sentence REGEXP '([^[:alnum:]]|^)web([^[:alnum:]]|$)'
Add Comment
Please, Sign In to add comment