mysql - Find strings within text in SQL -


i have table string column "word" , rather large text. want find words appear within text. imho need reverse operator. ist possible in plain sql (no stored procedures)?

example: finding words in rhymes

| id | word | | 1  | star | | 2  | moon | | 3  | sun  | | 4  | sky  | 

text: twinkle, twinkle, little star, how wonder are! above world high, diamond in sky.

==> should find id 1: start, 4: sky

try this:

select id tablename 'twinkle, twinkle, little star, how wonder are! above world high, diamond in sky.' concat('%', word, '%'); 

sql fiddle demo


Comments

Popular posts from this blog

java - Ebean enhancement ignores a model -

ubuntu - How to disable Kernel Module Signing in linux -

SQL php on different pages to Insert (mysqli) -