Status: Solved
Priority: Medium
Security: Public
Views: 304
Last Modified: 2013-06-25

Full Word Search Containing one word

I want to only get results that contain only @bob but my current query gets results with bob and bobby and other variations of bob.

$username = "bob";

$query = mysql_query("SELECT head.comment_id, friend_id, users.member_id, username, approved, UNIX_TIMESTAMP(date_posted) AS date_posted, comment_text, username FROM comments_head head FORCE INDEX(member_id), comments_body body, users WHERE head.comment_id = body.comment_id AND head.friend_id = users.member_id and body.comment_text LIKE '@$username%' order by head.comment_id desc limit " .$this->perpage) or die(mysql_error());

Open in new window

U_S_A

Asked: 2013-06-17

Advertise Here

1 Solution

LVL 111

Ray PaseurCommented: 2013-06-17

Change this...

'@$username%'

... to this and let us know how it works out.

'@$username'

I'm not sure - you might need to prepend the @ to the $username variable before constructing the query. But this is where I would start to test.

LVL 15

InsoftserviceCommented: 2013-06-22

change '@$username%' to '@$username'

$query = mysql_query("SELECT head.comment_id, friend_id, users.member_id, username, approved, UNIX_TIMESTAMP(date_posted) AS date_posted, comment_text, username FROM comments_head head FORCE INDEX(member_id), comments_body body, users WHERE head.comment_id = body.comment_id AND head.friend_id = users.member_id and body.comment_text LIKE '@$username' order by head.comment_id desc limit " .$this->perpage) or die(mysql_error());

LVL 111

Ray PaseurCommented: 2013-06-22

@insoftservice: Right.. Just like I said 5 days ago! ;-)

@U_S_A: You might try using var_dump() to print out the fully resolved query string. Also, see the note about the MySQL Wild Card here:
http://www.tizag.com/mysqlTutorial/mysqlwhere.php

LVL 15

InsoftserviceCommented: 2013-06-22

ya @Ray_Paseur.
just said by mysql long back when it had been developed if i am not wrong :).

Its one of common mysql wild card which normally all developers use right ?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Full Word Search Containing one word

Join & Write a Comment Already a member? Login.

Featured Post