how to split a string field sentence in mysql to words

Question

I am using a CMS for adding a new product. Along with adding the product I am giving an option to add keywords.

Keywords:<textarea rows="10" cols="20" name="keywords"></textarea>

Then it is inserted in to mysql table. But i want to use these keywords for a search option. Now it is saving as a string of sentences seperated by comma or space. How can I get each word back from the table?

http://stackoverflow.com/questions/6152137/mysql-string-split — Rishabh, Jun 13 '12 at 05:19
WHERE keyword like '%%' ? http://stackoverflow.com/questions/2749744/how-to-search-mulitple-value-seperated-by-commas-in-mysql — verisimilitude, Jun 13 '12 at 05:20

score 0 · Answer 1 · answered Jun 13 '12 at 05:19

0

You can find functions that deals with string-splitting here and here

answered Jun 13 '12 at 05:19

Nir Alfasi

53,191
11
86
129

score 0 · Answer 2 · answered Jun 13 '12 at 05:21

0

You can use the PHP method: explode($delimiter, $string).

Example:

$newArray = explode(' ', $yourPhraseWithSpaces);

or

$newArray = explode(',', $yourPhraseWithCommas);

answered Jun 13 '12 at 05:21

Silvio Delgado

6,798
3
18
22

score 0 · Answer 3 · answered Jun 13 '12 at 06:46

by using

array preg_split ( string $pattern , string $subject [, int $limit = -1 [, int $flags = 0 ]] )

or

 explode($delimiter,$string)

or

  spliti ( string $pattern , string $string [, int $limit = -1 ] )

or

  chunk_split ( string $body [, int $chunklen = 76 [, string $end = "\r\n" ]] )

or

  str_split ( string $string [, int $split_length = 1 ] )

how to split a string field sentence in mysql to words

3 Answers3

Linked