MySQL query that looks for substring in column?

Question

I'm using this query to look for User results. The problem is that it only finds exact matches. How do I make it check for string as substring in column User?

$result2 = mysql_query("SELECT * FROM `Users` WHERE MATCH (`User`) AGAINST ('$string') LIMIT 5");

Thanks

Shef · Accepted Answer · 2011-08-16 07:04:13Z

4

$result2 = mysql_query("SELECT * FROM `Users` WHERE `User` LIKE '%$string%' LIMIT 5");

Use the LIKE operator, that's what it's there for.

Also, I hope you are escaping the $string variable earlier in the code with mysql_real_escape_string to protect against SQL Injection.

answered Aug 16, 2011 at 7:04

Shef

45.6k15 gold badges82 silver badges91 bronze badges

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

Comments

scessor · Accepted Answer · 2011-08-16 07:04:29Z

1

$result2 = mysql_query("SELECT * FROM `Users` WHERE `User`LIKE '%".$string."%' LIMIT 5");

answered Aug 16, 2011 at 7:04

scessor

16.1k4 gold badges45 silver badges55 bronze badges

1 Comment

Shef Over a year ago

String concatenation is costly.

sdleihssirhc · Accepted Answer · 2011-08-16 07:04:46Z

1

Change your query to use the LIKE keyword and the % thingy-mabobber:

SELECT * FROM `Users` WHERE `User` LIKE '%$string%' LIMIT 5

answered Aug 16, 2011 at 7:04

sdleihssirhc

42.6k6 gold badges56 silver badges67 bronze badges

Comments

Naor · Accepted Answer · 2011-08-16 07:05:27Z

0

It should be something like:

SELECT * FROM pet WHERE name LIKE '%fy';

You can read more here.

answered Aug 16, 2011 at 7:05

Naor

24.3k50 gold badges158 silver badges273 bronze badges

Comments

HaaR · Accepted Answer · 2011-08-16 07:06:48Z

0

I think you want to use the LIKE operator.

Something along the lines of:

$result = mysql_query("SELECT * FROM `Users` WHERE `User` LIKE '%$string%' LIMIT 5");

http://www.w3schools.com/sql/sql_like.asp

answered Aug 16, 2011 at 7:06

HaaR

1,4532 gold badges14 silver badges21 bronze badges

Collectives™ on Stack Overflow

MySQL query that looks for substring in column?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related