MySQL check if column contains words from String

Question

Hi Im trying to make a keywords search for a java program I'm working on. I have run into a wall trying to work out how I can pass a string that contains 1-n words separated by spaces and then see if the column in the mysql database has any. If it contains at least one I want it to return the the selected data.

I have tried using the WHERE LIKE way of doing it but it doesnt seem to work

eg

SELECT `Data`
FROM `TABLE`
WHERE `Keywords` LIKE passedString

reverse the condition (i.e. test if passedString contains the "keywords") and use dev.mysql.com/doc/refman/5.7/en/… or maybe you could use dev.mysql.com/doc/refman/5.7/en/… — user180100
– user180100, Commented Oct 27, 2016 at 13:13

kapilpatwa93 · Accepted Answer · 2016-10-27 13:14:58Z

2

Use %, it represents zero, one, or multiple characters.

SELECT `Data`FROM `TABLE`WHERE `Keywords` LIKE '%passedString%'

answered Oct 27, 2016 at 13:14

kapilpatwa93

4,5012 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

C6912 Over a year ago

Will this split the passed string into characters? Or will they still be whole words?

kapilpatwa93 Over a year ago

I think so you got confused. It will return those rows which contains 'passedString' in 'Data' column.

Erik B from B · Accepted Answer · 2016-10-27 13:12:28Z

0

Try

SELECT `Data` FROM `TABLE` WHERE `Keywords` LIKE + '%' + passedString + '%'

But before you have to split the passed String into single Strings (words) and run your query in a loop until you find your desired result.

answered Oct 27, 2016 at 13:12

Erik B from B

625 bronze badges

Comments

Mohammad Nurul Huda Rimon · Accepted Answer · 2016-10-27 13:21:55Z

0

The "%" sign is used to define wildcards (missing letters) both before and after the pattern.

SELECT Data
FROM TABLE
WHERE Keywords LIKE '%passedString%'

% A substitute for zero or more characters.

answered Oct 27, 2016 at 13:21

Mohammad Nurul Huda Rimon

2,5351 gold badge17 silver badges18 bronze badges

Collectives™ on Stack Overflow

MySQL check if column contains words from String

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related